Development Experience with sharepoint, MVC, .net: October 2025

.NET Core 8.0 Program.cs

<?xml version="1.0" encoding="utf-8"?>

<system.webServer>

</handlers>

</system.webServer>

</location>

</configuration>

n ////: By default it will false make true to ////

{

"Logging": {

"LogLevel": {

"Default": "Information",

"Microsoft.AspNetCore": "Warning"

}

"AllowedHosts": "*",

"ConnectionStrings": { "sqlconnstr": "Data Source=databaseserver;Initial Catalog=[db];User ID=abcACCOUNT;Password=[pwd];TrustServerCertificate=True;Connection Timeout=900;" },

" office1Value": {

"frommail": "dev@enviabc.com",

"bccmail": "support@enviabc.com",

"mailport": "25", // in error check other ports: 25 or 465 or 587

"isrule": "1",

"encode1": "@$#W!N!",

"sqlconntimeout": "1800",

"serverpath": "\\\\dca-dev-sever\\",

"filePath": "\\\\dca-dev-server\\importantfiles\\",

"fileurl": "https://dca-dev-server/office1spm/#/files",

"assetUrl": "https://dca-dev-server/capital"

}

using Microsoft.AspNetCore.Authentication.Negotiate;

using Microsoft.Extensions.DependencyInjection.Extensions;

var builder = WebApplication.CreateBuilder(args);

// Add services to the container.

builder.Services.AddCors(options =>

{

options.AddPolicy("p1",

policy =>

{

policy.WithOrigins("http://localhost:8080", "https://localhost:8080",

"http://localhost:8000", "https://localhost:8000")

.AllowAnyHeader()

.AllowAnyMethod()

.AllowCredentials();

});

builder.Services.AddAuthentication(NegotiateDefaults.AuthenticationScheme).AddNegotiate();

//builder.Services.AddAuthorization(options => //enable when kestrel server, but Kestral not works properly with Windows Authentication.

//{

// options.FallbackPolicy = options.DefaultPolicy;

//});

builder.Services.TryAddSingleton<IHttpContextAccessor, HttpContextAccessor>();

builder.Services.AddControllers();

// Learn more about configuring Swagger/OpenAPI at https://aka.ms/aspnetcore/swashbuckle

builder.Services.AddEndpointsApiExplorer();

builder.Services.AddSwaggerGen();

var app = builder.Build();

// Configure the HTTP request pipeline.

if (app.Environment.IsDevelopment() || app.Environment.IsProduction())

{

app.UseSwagger();

app.UseSwaggerUI();

}

app.UseRouting();

app.UseCors("p1");

//app.UseHttpsRedirection();

app.UseAuthentication();

app.UseAuthorization();

app.MapControllers();

app.Run();

*======= * *======= * *======= * *======= * *======= * *======= * *======= * *======= *

public class MailSender : IMailSender

{

private static IConfiguration _configuration = new ConfigurationBuilder().AddJsonFile("appsettings.json").Build();

public static async Task<string> SendMail(string to, string cc, string subject, string message)

{

string fromAdd = _configuration["office1Value:frommail"];

string bccmail = _configuration["office1Value:bccmail"];

string mailport = _configuration["office1Value:mailport"];

string isrule = _configuration["office1Value:isrule"];

if (isrule == "1") ServicePointManager.SecurityProtocol = (SecurityProtocolType)(0xc0 | 0x300 | 0xc00);

MimeMessage mm = new MimeMessage();

MailboxAddress from = new MailboxAddress("", fromAdd);

mm.From.Add(from);

mm.Bcc.Add(new MailboxAddress("", bccmail.Trim()));

//// Add multiple 'To' addresses ////

foreach (var address in to.Split(new[] { ',' }, StringSplitOptions.RemoveEmptyEntries))

{

if (address.ToLower().EndsWith("@office1.com")) mm.To.Add(new MailboxAddress("", address.Trim()));

else

{

List<Users> oUsr = GetUserDetails(address.Trim());

foreach (Users u in oUsr)

if (u.DisplayName == address || u.Email.ToLower() == address.ToLower() || u.UserName.ToLower().Replace("office1\\", "") == address.ToLower().Replace("office1\\", ""))

mm.To.Add(new MailboxAddress("", u.Email.Trim()));

}

// // Add multiple 'Cc' addresses ////

if (!string.IsNullOrWhiteSpace(cc))

foreach (var address in cc.Split(new[] { ',' }, StringSplitOptions.RemoveEmptyEntries))

{

if (address.ToLower().EndsWith("@office1.com")) mm.To.Add(new MailboxAddress("", address.Trim()));

else

{

List<Users> oUsr = GetUserDetails(address.Trim());

foreach (Users u in oUsr)

if (u.DisplayName == address || u.Email.ToLower() == address.ToLower() || u.UserName.ToLower().Replace("office1\\", "") == address.ToLower().Replace("office1\\", ""))

mm.Cc.Add(new MailboxAddress("", u.Email.Trim()));

}

mm.Subject = subject;

mm.Body = new TextPart("html") { Text = message };

//mm.Cc.ad = message;

using (var client = new SmtpClient())

{

//client.Connect("mailserver.office1.com", Convert.ToInt32(mailport), false);

await client.ConnectAsync("mailserver.office1.com", Convert.ToInt32(mailport), false);

//client.AuthenticateAsync("", "");

// Send the email

//client.Send(mm);

await client.SendAsync(mm);

// Disconnect from the SMTP server

//client.Disconnect(true);

await client.DisconnectAsync(true);

}

mm.Dispose();

return "success";

}

public static async Task<string> SendMailCoreStd(string to, string cc, string subject, string message)

{

string fromAdd = _configuration["apaValue:frommail"];

string bccmail = _configuration["Office1Value:bccmail"];

string mailport = _configuration["Office1Value:mailport"];

string isrule = _configuration["Office1Value:isrule"];

if (isrule == "1") ServicePointManager.SecurityProtocol = (SecurityProtocolType)(0xc0 | 0x300 | 0xc00);

MimeMessage mm = new MimeMessage();

MailboxAddress from = new MailboxAddress("", fromAdd);

mm.From.Add(from);

mm.Bcc.Add(new MailboxAddress("", bccmail.Trim()));

//// Add multiple 'To' addresses ////

foreach (var address in to.Split(new[] { ',' }, StringSplitOptions.RemoveEmptyEntries))

mm.To.Add(new MailboxAddress("", address.Trim()));

// // Add multiple 'Cc' addresses ////

if (!string.IsNullOrWhiteSpace(cc))

foreach (var address in cc.Split(new[] { ',' }, StringSplitOptions.RemoveEmptyEntries))

mm.Cc.Add(new MailboxAddress("", address.Trim()));

mm.Subject = subject;

mm.Body = new TextPart("html") { Text = message };

//mm.Cc.ad = message;

using (var client = new SmtpClient())

{

//client.Connect("mailserver.office1.com", Convert.ToInt32(mailport), false);

await client.ConnectAsync("mailserver.office1.com", Convert.ToInt32(mailport), false);

//client.AuthenticateAsync("", "");

// Send the email

//client.Send(mm);

await client.SendAsync(mm);

// Disconnect from the SMTP server

//client.Disconnect(true);

await client.DisconnectAsync(true);

}

mm.Dispose();

return "success";

}

public string SendMail1(string to, string cc, string subject, string message)

{

ServicePointManager.SecurityProtocol = (SecurityProtocolType)(0xc0 | 0x300 | 0xc00);

MimeMessage mm = new MimeMessage();

MailboxAddress from = new MailboxAddress("OFFICE1 DEV", "ai_dev@office1.com");

MailboxAddress toM = new MailboxAddress("", to);

mm.From.Add(from);

mm.To.Add(toM);

mm.Subject = subject;

mm.Body = new TextPart("plain") { Text = message };

//mm.Cc.ad = message;

using (var client = new SmtpClient())

{

client.ConnectAsync("mailserver.office1.com", 25, false);

//client.AuthenticateAsync("", "");

// Send the email

client.SendAsync(mm);

// Disconnect from the SMTP server

client.DisconnectAsync(true);

}

mm.Dispose();

return "success";

}

internal static List<Users> GetUserDetails(string sKey)

{

sKey = sKey.Contains("office1\\") ? sKey.Replace("office1\\", "") : sKey;

List<Users> lstADUsers = new List<Users>();

try

{

string DomainPath = "LDAP://DC=office1,DC=com";

DirectoryEntry searchRoot = new DirectoryEntry(DomainPath);

DirectorySearcher search = new DirectorySearcher(searchRoot);

search.Filter = string.Format("(mail={0})", sKey);

search.PropertiesToLoad.Add("samaccountname");

search.PropertiesToLoad.Add("mail");

search.PropertiesToLoad.Add("sn");

search.PropertiesToLoad.Add("usergroup");

search.PropertiesToLoad.Add("displayname");//first name

search.PropertiesToLoad.Add("objectCategory");

search.PropertiesToLoad.Add("objectClass");

search.SizeLimit = 25;

SearchResult result;

SearchResultCollection resultCol = search.FindAll();

if (resultCol != null && resultCol.Count < 1)

{

search.Filter = string.Format("(sAMAccountName={0})", sKey);

search.SizeLimit = 25;

result = null;

resultCol = null;

resultCol = search.FindAll();

}

if (resultCol != null && resultCol.Count < 1)

{

search.Filter = string.Format("(&(|(objectClass=user)(objectClass=group))(anr={0}))", sKey);

search.SizeLimit = 25;

result = null;

resultCol = null;

resultCol = search.FindAll();

}

if (resultCol != null)

{

for (int counter = 0; counter < resultCol.Count; counter++)

{

string UserNameEmailString = string.Empty;

result = resultCol[counter];

if (result.Properties.Contains("samaccountname") &&

result.Properties.Contains("mail") &&

result.Properties.Contains("displayname"))

{

Users objSurveyUsers = new Users();

objSurveyUsers.Email = (String)result.Properties["mail"][0];

objSurveyUsers.UserName = (String)result.Properties["samaccountname"][0];

objSurveyUsers.DisplayName = (String)result.Properties["displayname"][0];

if (Convert.ToString((String)result.Properties["objectCategory"][0]).ToLower().Contains("group"))

objSurveyUsers.UserType = "Group";

else if (Convert.ToString((String)result.Properties["objectCategory"][0]).ToLower().Contains("person"))

objSurveyUsers.UserType = "Person";

else

objSurveyUsers.UserType = "";

lstADUsers.Add(objSurveyUsers);

}

catch (Exception ex)

{

throw ex;

}

return lstADUsers;

}

public class FileManage

{/// <summary>

/// GET files from folder on DRive

/// </summary>

public static List<string> GetFiles(string path)

{

List<string> lst = new List<string>();

DirectoryInfo d = new DirectoryInfo(path);

if (!d.Exists)

System.IO.Directory.CreateDirectory(path);

FileInfo[] Files = d.GetFiles();

foreach (FileInfo file in Files)

lst.Add(file.Name);

return lst;

}

/// <summary>

/// GET files from folder on DRive

/// </summary>

public static async Task<string> SaveFiles(string path, IFormFile postedFile)

{

try

{

//// Delete 2 days old files from temp folder ////

if (path.EndsWith(Office1Const.TEMP_FOLDER_NAME) && System.IO.Directory.Exists(path))

{

string[] files = Directory.GetFiles(path);

foreach (string file in files)

{

FileInfo fi = new FileInfo(file);

if (fi.CreationTime < DateTime.Now.AddDays(-2))

fi.Delete();

}

//// Save file ////

bool exists = System.IO.Directory.Exists(path);

if (!exists)

System.IO.Directory.CreateDirectory(path);

//var filePath = Path.GetTempFileName();

var filePath = path + "\\" + RemoveSpecialCharacters(postedFile.FileName.Trim());

if (postedFile.Length > 0)

{

using (var stream = new FileStream(filePath, FileMode.Create))

{

await postedFile.CopyToAsync(stream);

}

return postedFile.FileName;

}

catch (Exception ex)

{

Helper.WriteToLog("OFFICE1_API", "Office1->TslSamApproval()", ex);

return ex.Message;

}

/// <summary>

/// coping temporary folder to permanent Allocation folder

/// </summary>

public static void CopyFilesTempToPermanent(string curPath, string destPath, string fileName)

{

try

{

System.IO.File.Copy(curPath + "/" + fileName, destPath + "/" + fileName);

}

catch (Exception Ex)

{ throw Ex; }

}

public static string RemoveSpecialCharacters(string str)

{

return Regex.Replace(str, "[^a-zA-Z0-9_.]+", "_");

}

public class Helper

{

private static IConfiguration _configuration = new ConfigurationBuilder().AddJsonFile("appsettings.json").Build();

private string enc = "@$#W";

private readonly IConfiguration _conf;

public Helper(IConfiguration configuration)

{

_conf = configuration;

}

public static bool EnsureUserInADGroup(string groupName, string userName)

{

bool retValue = false;

try

{

userName = userName.Replace("office1\\", "");

PrincipalContext ctx = new PrincipalContext(ContextType.Domain, "office1Support");

UserPrincipal user = UserPrincipal.FindByIdentity(ctx, userName);

GroupPrincipal grp = GroupPrincipal.FindByIdentity(ctx, IdentityType.Name, groupName);

if (user != null && grp != null)

{

retValue = grp.GetMembers(true).Contains(user);

grp.Dispose();

}

catch (Exception)

{ retValue = false; }

return retValue;

}

public static string ConString()

{/*

OdbcConnectionStringBuilder builder = new OdbcConnectionStringBuilder();

builder.Driver = "{Simba Spark ODBC Driver}"; // Or the exact name of your installed Databricks ODBC driver

builder.Add("Host", "adb-.2.azuredatabricks.net");//adb-260329400975751.11.azuredatabricks.net

builder.Add("Port", "443"); // Standard port for HTTPS

builder.Add("ThriftTransport", "2");

builder.Add("AuthMech", "3"); // For Personal Access Token authentication

builder.Add("UID", "token");

builder.Add("PWD", "dapi7b11e9fab06");//QA token: dapi3d46de2ff318418ed318 dev token: dapi7b11e9af06339fab06 for

builder.Add("HTTPPath", "sql/1.0/warehouses/7abfa322");// /sql/1.0/warehouses/7a8fa2322

builder.Add("SSL", "1"); // Enable SSL/TLS

return builder.ConnectionString;

OdbcConnectionStringBuilder builder = new OdbcConnectionStringBuilder();

builder.Driver = "{Simba Spark ODBC Driver}"; // Or the exact name of your installed Databricks ODBC driver

builder.Add("Host", "adb-.2.azuredatabricks.net");//adb-260329400975751.11.azuredatabricks.net

builder.Add("Port", "443"); // Standard port for HTTPS

builder.Add("ThriftTransport", "2");

builder.Add("AuthMech", "3"); // For Personal Access Token authentication

builder.Add("UID", "token");

builder.Add("PWD", "dapieafds21334");//QA token: dapieafds21334dev token: dapieafds21334 for ashwini

builder.Add("HTTPPath", "/sql/1.0/warehouses/dapieafds21334");// /sql/1.0/warehouses/7ab4f659f8fa2322

builder.Add("SSL", "1"); // Enable SSL/TLS

return builder.ConnectionString;

}

public DataSet GetResultFromSQLDatabase(string cmdText, List<SqlParameter> paramColl)

{

DataSet dsResult = new DataSet();

string configuration = _conf.GetConnectionString("sqlconnstr");

string pw = _conf["Office1Value:encode1"];

pw = pw.Replace(enc, "");

configuration = configuration.Replace("[pwd]", pw);

configuration = configuration.Replace("[db]", "IMDb");

using (SqlConnection connection = new SqlConnection(configuration))

{

SqlDataAdapter sqlAdapter;

SqlCommand sqlCommand;

sqlCommand = new SqlCommand(cmdText, connection);

sqlCommand.CommandType = CommandType.StoredProcedure;

if (!string.IsNullOrEmpty(_conf["Office1Value:sqlconntimeout"]))

sqlCommand.CommandTimeout = Convert.ToInt32(_conf["Office1Value:sqlconntimeout"]);

foreach (SqlParameter p in paramColl)

sqlCommand.Parameters.Add(p);

sqlAdapter = new SqlDataAdapter(sqlCommand);

sqlAdapter.Fill(dsResult);

sqlAdapter.Dispose();

sqlCommand.Dispose();

}

return dsResult;

}

public string BulkCopyToTable(DataTable dtMasterData, string TableName)

{

string configuration = _conf.GetConnectionString("sqlconnstr");

string pw = _conf["Office1Value:encode1"];

pw = pw.Replace(enc, "");

configuration = configuration.Replace("[pwd]", pw);

configuration = configuration.Replace("[db]", "SPM");

using (SqlConnection connection = new SqlConnection(configuration))

{

connection.Open();

SqlBulkCopy bulkCopy = new SqlBulkCopy(connection);

bulkCopy.BulkCopyTimeout = 3000;

bulkCopy.DestinationTableName = TableName.ToUpper();

foreach (DataColumn column in dtMasterData.Columns)

{

bulkCopy.ColumnMappings.Add(column.ColumnName, column.ColumnName);

}

bulkCopy.WriteToServer(dtMasterData);

connection.Close();

}

return "Data Inserted Successfully.";

}

public static void WriteToLog(string page, string method, Exception ex)

{

List<SqlParameter> sqlParam = new List<SqlParameter>();

SqlParameter p1 = new SqlParameter("@Page", SqlDbType.NVarChar);

p1.Value = page;

sqlParam.Add(p1);

SqlParameter p2 = new SqlParameter("@Method", SqlDbType.NVarChar);

p2.Value = method;

sqlParam.Add(p2);

SqlParameter p3 = new SqlParameter("@Message", SqlDbType.NVarChar);

p3.Value = ex.Message;

sqlParam.Add(p3);

SqlParameter p4 = new SqlParameter("@StackTrace", SqlDbType.NVarChar);

p4.Value = ex.StackTrace;

sqlParam.Add(p4);

GetResultFromSqlDatabase("[dbo].[usp_ExceptionLog]", sqlParam, Office1Const.PART_VIEWER);

}

public static DataSet GetResultFromSqlDatabase(string cmdText, List<SqlParameter> paramColl, string dbName)

{

DataSet dsResult = new DataSet();

string configuration = _configuration.GetConnectionString("sqlconnstr");

string pw = _configuration["Office1Value:encode1"];

pw = pw.Replace("@$#W", "");

configuration = configuration.Replace("[pwd]", pw);

switch (dbName)

{

case "IMDb":

configuration = configuration.Replace("[db]", "IMmmddd");

break;

case "PART_VIEWER":

configuration = configuration.Replace("[db]", "PARTSOFMACHINE");

break;

case "":

configuration = configuration.Replace("[db]", "");

break;

}

using (SqlConnection connection = new SqlConnection(configuration))

{

SqlDataAdapter sqlAdapter;

SqlCommand sqlCommand;

sqlCommand = new SqlCommand(cmdText, connection);

sqlCommand.CommandType = CommandType.StoredProcedure;

if (!string.IsNullOrEmpty(_configuration["sqlconntimeout"]))

sqlCommand.CommandTimeout = Convert.ToInt32(_configuration["sqlconntimeout"]);

foreach (SqlParameter p in paramColl)

sqlCommand.Parameters.Add(p);

sqlAdapter = new SqlDataAdapter(sqlCommand);

sqlAdapter.Fill(dsResult);

sqlAdapter.Dispose();

sqlCommand.Dispose();

}

return dsResult;

}

/// <summary>

/// common method to converting datatable into XML

/// </summary>

public static string ConvertDataTableToXML(DataTable oDataTable, string DtKeyName)

{

StringBuilder sb = new StringBuilder();

sb.Append("<NewDataSet>");

for (int i = 0; i < oDataTable.Rows.Count; i++)

{

if (oDataTable.Columns.Count > 0)

{

sb.Append("<" + DtKeyName + " ");

for (int col = 0; col < oDataTable.Columns.Count; col++)

sb.Append(oDataTable.Columns[col].ColumnName.Replace(" ", "") + "=\"" + Convert.ToString(oDataTable.Rows[i][col]).Replace("&", "&").Replace("\"", """) + "\" ");

sb.Append(" />");

}

sb.Append("</NewDataSet>");

return sb.ToString();

}

public static string EncodeBase64(string plainText)

{

var plainTextBytes = System.Text.Encoding.UTF8.GetBytes(plainText);

return System.Convert.ToBase64String(plainTextBytes);

}

public static string DecodeBase64(string base64EncodedData)

{

var base64EncodedBytes = System.Convert.FromBase64String(base64EncodedData);

return System.Text.Encoding.UTF8.GetString(base64EncodedBytes);

}

public static string GetAppConfigValue(string str)

{

return Convert.ToString(_configuration[str]);

}

public class Result

{

public string IsSuccess { set; get; }

public string Message { set; get; } = string.Empty;

public int Valid { get; set; }

}

public class ADAttribute

{

public static ADAttributes GetADAttibutes(string empID)

{

using (var context = new PrincipalContext(ContextType.Domain, Office1Const.OFFICE1))

{

var user = UserPrincipal.FindByIdentity(context, empID);

if (user != null)

{

//userProperties.EmpName = user.Name;

DirectoryEntry sresult = user.GetUnderlyingObject() as DirectoryEntry;

ADAttributes objAd = new ADAttributes

{

employeeId = sresult.Properties["employeeid"].Count > 0 ? sresult.Properties["employeeid"][0].ToString() : string.Empty,

employeeType = sresult.Properties["employeeType"].Count > 0 ? sresult.Properties["employeeType"][0].ToString() : string.Empty,

sAMAccountName = sresult.Properties["sAMAccountName"].Count > 0 ? sresult.Properties["sAMAccountName"][0].ToString() : string.Empty,

department = sresult.Properties["department"].Count > 0 ? sresult.Properties["department"][0].ToString() : string.Empty,

departmentNumber = sresult.Properties["departmentNumber"].Count > 0 ? sresult.Properties["departmentNumber"][0].ToString() : string.Empty,

division = sresult.Properties["division"].Count > 0 ? sresult.Properties["division"][0].ToString() : string.Empty,

manager = sresult.Properties["manager"].Count > 0 ? sresult.Properties["manager"][0].ToString() : string.Empty,

managerSamAcnt = (sresult.Properties.Contains("manager") == true) ? Convert.ToString(sresult.Properties["manager"][0]).Split(',')[0].Split('=')[1] : string.Empty, // Splitting manger name

displayName = sresult.Properties["displayName"].Count > 0 ? sresult.Properties["displayName"][0].ToString() : string.Empty,

PhysicalDeliveryOfficeName = sresult.Properties["physicalDeliveryOfficeName"].Count > 0 ? sresult.Properties["physicalDeliveryOfficeName"][0].ToString() : string.Empty,

mail = sresult.Properties["mail"].Count > 0 ? sresult.Properties["mail"][0].ToString() : string.Empty,

memberOf = sresult.Properties["memberOf"].Count > 0 ? sresult.Properties["memberOf"][0].ToString() : string.Empty,

userAccountControl = sresult.Properties["userAccountControl"].Count > 0 ? sresult.Properties["userAccountControl"][0].ToString() : string.Empty,

givenName = sresult.Properties["givenName"].Count > 0 ? sresult.Properties["givenName"][0].ToString() : string.Empty,

objectClass = sresult.Properties["objectClass"].Count > 0 ? sresult.Properties["objectClass"][0].ToString() : string.Empty,

postOfficeBox = sresult.Properties["postOfficeBox"].Count > 0 ? sresult.Properties["postOfficeBox"][0].ToString() : string.Empty,

telephoneNumber = sresult.Properties["telephoneNumber"].Count > 0 ? sresult.Properties["telephoneNumber"][0].ToString() : string.Empty,

uId = sresult.Properties["uId"].Count > 0 ? sresult.Properties["uId"][0].ToString() : string.Empty,

Location = sresult.Properties["L"].Count > 0 ? sresult.Properties["L"][0].ToString() : string.Empty,

Company = sresult.Properties["Company"].Count > 0 ? sresult.Properties["Company"][0].ToString() : string.Empty,

FirstName = sresult.Properties["givenName"].Count > 0 ? sresult.Properties["givenName"][0].ToString() : string.Empty,

LastName = sresult.Properties["sn"].Count > 0 ? sresult.Properties["sn"][0].ToString() : string.Empty,

co = sresult.Properties["co"].Count > 0 ? sresult.Properties["co"][0].ToString() : string.Empty

};

return objAd;

}

else

return new ADAttributes();

}

internal static List<Users> GetUserDetails(string sKey)

{

sKey = sKey.Contains("OFFICE1\\") ? sKey.Replace("OFFICE1\\", "") : sKey;

List<Users> lstADUsers = new List<Users>();

try

{

string DomainPath = "LDAP://DC=OFFICE1,DC=com";

DirectoryEntry searchRoot = new DirectoryEntry(DomainPath);

DirectorySearcher search = new DirectorySearcher(searchRoot);

search.Filter = string.Format("(mail={0})", sKey);

search.PropertiesToLoad.Add("samaccountname");

search.PropertiesToLoad.Add("mail");

search.PropertiesToLoad.Add("sn");

search.PropertiesToLoad.Add("usergroup");

search.PropertiesToLoad.Add("displayname");//first name

search.PropertiesToLoad.Add("objectCategory");

search.PropertiesToLoad.Add("objectClass");

search.PropertiesToLoad.Add("thumbnailPhoto");

search.PropertiesToLoad.Add("manager");

search.SizeLimit = 25;

SearchResult result;

SearchResultCollection resultCol = search.FindAll();

if (resultCol != null)

{

for (int counter = 0; counter < resultCol.Count; counter++)

{

string UserNameEmailString = string.Empty;

result = resultCol[counter];

if (result.Properties.Contains("samaccountname") &&

result.Properties.Contains("mail") &&

result.Properties.Contains("displayname"))

{

Users objSurveyUsers = new Users();

objSurveyUsers.Email = (String)result.Properties["mail"][0];

objSurveyUsers.ManagerSamAcnt = (result.Properties.Contains("manager") == true) ? Convert.ToString(result.Properties["manager"][0]).Split(',')[0].Split('=')[1] : string.Empty;

objSurveyUsers.UserName = (String)result.Properties["samaccountname"][0];

objSurveyUsers.DisplayName = (String)result.Properties["displayname"][0];

if (result.Properties.Contains("thumbnailPhoto"))

objSurveyUsers.Thumbnail = result.Properties["thumbnailPhoto"][0] as byte[];

if (Convert.ToString((String)result.Properties["objectCategory"][0]).ToLower().Contains("group"))

objSurveyUsers.UserType = "Group";

else if (Convert.ToString((String)result.Properties["objectCategory"][0]).ToLower().Contains("person"))

objSurveyUsers.UserType = "Person";

else

objSurveyUsers.UserType = "";

lstADUsers.Add(objSurveyUsers);

}

search.Filter = string.Format("(sAMAccountName={0})", sKey);

search.SizeLimit = 25;

//search.PropertiesToLoad.Add("*");

result = null;

resultCol = null;

resultCol = search.FindAll();

if (resultCol != null)

{

for (int counter = 0; counter < resultCol.Count; counter++)

{

string UserNameEmailString = string.Empty;

result = resultCol[counter];

if (result.Properties.Contains("samaccountname") &&

result.Properties.Contains("mail") &&

result.Properties.Contains("displayname"))

{

Users objSurveyUsers = new Users();

objSurveyUsers.Email = (String)result.Properties["mail"][0];

objSurveyUsers.ManagerSamAcnt = (result.Properties.Contains("manager") == true) ? Convert.ToString(result.Properties["manager"][0]).Split(',')[0].Split('=')[1] : string.Empty;

objSurveyUsers.UserName = (String)result.Properties["samaccountname"][0];

objSurveyUsers.DisplayName = (String)result.Properties["displayname"][0];

if (result.Properties.Contains("thumbnailPhoto"))

objSurveyUsers.Thumbnail = result.Properties["thumbnailPhoto"][0] as byte[];

if (Convert.ToString((String)result.Properties["objectCategory"][0]).ToLower().Contains("group"))

objSurveyUsers.UserType = "Group";

else if (Convert.ToString((String)result.Properties["objectCategory"][0]).ToLower().Contains("person"))

objSurveyUsers.UserType = "Person";

else

objSurveyUsers.UserType = "";

lstADUsers.Add(objSurveyUsers);

}

search.Filter = string.Format("(&(objectClass=user)(givenname={0}*))", sKey); ;//string.Format("(&(objectClass=user)(givenname=ashwini))");//"(&(objectClass=user)(givenname=Ash*)(sn=A))";//"((sAMAccountName=))"; //(mail = ashwini_sharma@contractor.office1.com)// |(mail=mat.com)

search.SizeLimit = 25;

result = null;

resultCol = null;

resultCol = search.FindAll();

if (resultCol != null)

{

for (int counter = 0; counter < resultCol.Count; counter++)

{

string UserNameEmailString = string.Empty;

result = resultCol[counter];

if (result.Properties.Contains("samaccountname") &&

result.Properties.Contains("mail") &&

result.Properties.Contains("displayname"))

{

Users objSurveyUsers = new Users();

objSurveyUsers.Email = (String)result.Properties["mail"][0];

objSurveyUsers.ManagerSamAcnt = (result.Properties.Contains("manager") == true) ? Convert.ToString(result.Properties["manager"][0]).Split(',')[0].Split('=')[1] : string.Empty;

objSurveyUsers.UserName = (String)result.Properties["samaccountname"][0];

objSurveyUsers.DisplayName = (String)result.Properties["displayname"][0];

if (Convert.ToString((String)result.Properties["objectCategory"][0]).ToLower().Contains("group"))

objSurveyUsers.UserType = "Group";

else if (Convert.ToString((String)result.Properties["objectCategory"][0]).ToLower().Contains("person"))

objSurveyUsers.UserType = "Person";

else

objSurveyUsers.UserType = "";

lstADUsers.Add(objSurveyUsers);

}

catch (Exception ex)

{

Users objSurveyUsers = new Users();

objSurveyUsers.Email = "Error";

objSurveyUsers.UserName = "Error";

objSurveyUsers.DisplayName = ex.Message;

lstADUsers.Add(objSurveyUsers);

}

return lstADUsers;

}

public static IEnumerable<Users> GetPeoples(string sKey)

{

sKey = sKey.Contains("OFFICE1\\") ? sKey.Replace("OFFICE1\\", "") : sKey;

List<Users> lstADUsers = new List<Users>();

try

{

string DomainPath = "LDAP://DC=OFFICE1,DC=com";

DirectoryEntry searchRoot = new DirectoryEntry(DomainPath);

DirectorySearcher search = new DirectorySearcher(searchRoot);

search.Filter = string.Format("(mail={0})", sKey);

search.PropertiesToLoad.Add("samaccountname");

search.PropertiesToLoad.Add("mail");

search.PropertiesToLoad.Add("sn");

search.PropertiesToLoad.Add("usergroup");

search.PropertiesToLoad.Add("displayname");//first name

search.PropertiesToLoad.Add("objectCategory");

search.PropertiesToLoad.Add("objectClass");

search.PropertiesToLoad.Add("manager");

search.SizeLimit = 25;

SearchResult result;

SearchResultCollection resultCol = search.FindAll();

search.Filter = string.Format("(&(|(objectClass=user)(objectClass=group))(anr={0}))", sKey);

//search.Filter = string.Format("(&(objectClass=user)(givenname={0}))", sKey);

//search.Filter = string.Format("(&(objectClass = user)(| (displayName = *{0} *)(givenName = *{0} *)(sn = *{0} *)))", sKey);

search.SizeLimit = 25;

result = null;

resultCol = null;

resultCol = search.FindAll();

if (resultCol != null)

{

for (int counter = 0; counter < resultCol.Count; counter++)

{

string UserNameEmailString = string.Empty;

result = resultCol[counter];

if (result.Properties.Contains("samaccountname") &&

result.Properties.Contains("mail") &&

result.Properties.Contains("displayname"))

{

Users objSurveyUsers = new Users();

objSurveyUsers.Email = (String)result.Properties["mail"][0];

objSurveyUsers.ManagerSamAcnt = (result.Properties.Contains("manager") == true) ? Convert.ToString(result.Properties["manager"][0]).Split(',')[0].Split('=')[1] : string.Empty;

objSurveyUsers.UserName = (String)result.Properties["samaccountname"][0];

objSurveyUsers.DisplayName = (String)result.Properties["displayname"][0];

if (Convert.ToString((String)result.Properties["objectCategory"][0]).ToLower().Contains("group"))

objSurveyUsers.UserType = "Group";

else if (Convert.ToString((String)result.Properties["objectCategory"][0]).ToLower().Contains("person"))

objSurveyUsers.UserType = "Person";

else

objSurveyUsers.UserType = "";

lstADUsers.Add(objSurveyUsers);

}

catch (Exception ex)

{

Users objSurveyUsers = new Users();

objSurveyUsers.Email = "Error";

objSurveyUsers.UserName = "Error";

objSurveyUsers.DisplayName = ex.Message;

lstADUsers.Add(objSurveyUsers);

}

return lstADUsers;

}

public class ADAttributes

{

public string employeeId { get; set; }

public string employeeType { get; set; }

public string mail { get; set; }

public string sAMAccountName { get; set; }

public string displayName { get; set; }

public string givenName { get; set; }

public string manager { get; set; }

public string memberOf { get; set; }

public string department { get; set; }

public string departmentNumber { get; set; }

public string division { get; set; }

public string userAccountControl { get; set; }

public string telephoneNumber { get; set; }

public string postOfficeBox { get; set; }

public string PhysicalDeliveryOfficeName { get; set; }

public string objectClass { get; set; }

public string uId { get; set; }

public string domain { get; set; }

public string Location { get; set; }

public string Company { get; set; }

public string FirstName { get; set; }

public string LastName { get; set; }

public string managerSamAcnt { get; set; }

public string ManagerEmail { get; set; }

public string ManagerLoginName { get; set; }

public string ManagerDisplayName { get; set; }

public string ManagerDomain { get; set; }

public string co { get; set; }

public string ManagerEmployeeID { get; set; }

public string ManagerPhoneNumber { get; set; }

}

public class Result

{

public string IsSuccess { set; get; }

public string Message { set; get; } = string.Empty;

public int Valid { get; set; }

}

public class Users

{

public string Email { get; set; }

public string UserName { get; set; }

public string DisplayName { get; set; }

public string UserType { get; set; }

public byte[] Thumbnail { get; set; }

public string ManagerSamAcnt { get; set; }

}

====================================================

Excel reading - by -- Microsoft default openxml package. -- - --- -

using DocumentFormat.OpenXml.Packaging;

using DocumentFormat.OpenXml.Spreadsheet;

using Microsoft.AspNetCore.Http;

using System.Data;

namespace AM.ASHEET

{

public class ESheet

{

public static DataTable ReadExcelToDTable(IFormFile file, int col)

{

DataTable dt = new DataTable();

using (SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.Open(file.OpenReadStream(), false))

{

WorkbookPart workbookPart = spreadsheetDocument.WorkbookPart;

Sheet sheet = workbookPart.Workbook.Descendants<Sheet>().First();

WorksheetPart worksheetPart = (WorksheetPart)workbookPart.GetPartById(sheet.Id);

SheetData sheetData = worksheetPart.Worksheet.Elements<SheetData>().First();

IEnumerable<Row> rows = sheetData.Descendants<Row>();

int icnt = 0;

foreach (Cell cell in rows.ElementAt(0))

{

if (icnt < col)

dt.Columns.Add(GetCellValue(spreadsheetDocument, cell));

icnt++;

}

foreach (Row row in rows) //this will also include your header row...

{

DataRow tempRow = dt.NewRow();

for (int i = 0; i < col; i++)

{

tempRow[i] = GetCellValue(spreadsheetDocument, row.Descendants<Cell>().ElementAt(i));

}

dt.Rows.Add(tempRow);

}

dt.Rows.RemoveAt(0);

return dt;

}

public static string GetCellValue(SpreadsheetDocument document, Cell cell)

{

SharedStringTablePart stringTablePart = document.WorkbookPart.SharedStringTablePart;

string value = cell.CellValue.InnerXml;

if (cell.DataType != null && cell.DataType.Value == CellValues.SharedString)

{

return stringTablePart.SharedStringTable.ChildElements[Int32.Parse(value)].InnerText;

}

else

{

return value;

}

[HttpPost]

[Route("IProjUpload")]

public Result InvProjAdminTslUpload(IFormFile file)

{

Result er = new Result();

try

{

if (file != null || file.Length > 0)

{

var httpRequest = _iHttpContextAccessor.HttpContext.Request;

DataTable dt = new ESheet().ReadExcelToDTable(file, 5);

er.Message += "ash";

}

catch (Exception ex)

{

//Helper.WriteToLog("API", " -> IProjUpload ()", ex);

er.IsSuccess = AConst.FAIL;

er.Message = ex.Message;

}

return er;

PROGRAM .CS

using Microsoft.AspNetCore.Authentication.Negotiate;

using Microsoft.Extensions.DependencyInjection.Extensions;

internal class Program

{

private static void Main(string[] args)

{

var builder = WebApplication.CreateBuilder(args);

builder.Services.AddCors(options =>

{

options.AddPolicy("p1",

policy =>

{

policy.WithOrigins("http://localhost:8080",

"https://localhost:8080")

.AllowAnyHeader()

.AllowAnyMethod();

});

});// ash: for cors api and site access allowing

// Add services to the container. //"https://dca-dev-997",

//windows authentication

builder.Services.AddAuthentication(NegotiateDefaults.AuthenticationScheme).AddNegotiate();

builder.Services.AddAuthorization(options =>

{

options.FallbackPolicy = options.DefaultPolicy;

}); //ash: for windows authentication

//builder.Services.AddAuthentication(NegotiateDefaults.AuthenticationScheme).AddNegotiate();

//builder.Services.AddAuthorization(options =>

//{

// // By default, all incoming requests will be authorized according to the default policy.

// options.FallbackPolicy = options.DefaultPolicy;

//});

builder.Services.TryAddSingleton<IHttpContextAccessor, HttpContextAccessor>();//ash: for http context

builder.Services.AddControllers();

// Learn more about configuring Swagger/OpenAPI at https://aka.ms/aspnetcore/swashbuckle

builder.Services.AddEndpointsApiExplorer();

builder.Services.AddSwaggerGen();

var app = builder.Build();

// Configure the HTTP request pipeline.

if (app.Environment.IsDevelopment() || app.Environment.IsProduction()) //ash:swagger in prod

{

app.UseSwagger();

app.UseSwaggerUI();

}

app.UseRouting();

app.UseCors("p1"); //app.UseCors();

app.UseAuthentication();

app.UseAuthorization();

//app.UseAuthentication(WindowsPrincipal);

app.MapControllers();

app.Run();

}

working on - : woring on today

using Microsoft.AspNetCore.Authentication.Negotiate;

using Microsoft.Extensions.DependencyInjection.Extensions;

var builder = WebApplication.CreateBuilder(args);

// Add services to the container.

builder.Services.AddCors(options =>

{

options.AddPolicy("p1",

policy =>

{

policy.WithOrigins("http://localhost:8080",

"https://localhost:8080")

.AllowAnyHeader()

.AllowAnyMethod()

.AllowCredentials();

});

//builder.Services.AddCors(options =>

//{

// options.AddDefaultPolicy(

// policy =>

// {

// policy.WithOrigins("http://localhost:8080")

// .AllowAnyHeader()

// .AllowAnyMethod()

// .AllowCredentials();

// });

//});

builder.Services.AddAuthentication(NegotiateDefaults.AuthenticationScheme).AddNegotiate();

builder.Services.AddAuthorization(options =>

{

options.FallbackPolicy = options.DefaultPolicy;

});

builder.Services.TryAddSingleton<IHttpContextAccessor, HttpContextAccessor>();

builder.Services.AddControllers();

// Learn more about configuring Swagger/OpenAPI at https://aka.ms/aspnetcore/swashbuckle

builder.Services.AddEndpointsApiExplorer();

builder.Services.AddSwaggerGen();

var app = builder.Build();

// Configure the HTTP request pipeline.

if (app.Environment.IsDevelopment() || app.Environment.IsProduction())

{

app.UseSwagger();

app.UseSwaggerUI();

}

app.UseCors("p1");

app.UseHttpsRedirection();

app.UseAuthentication();

app.UseAuthorization();

app.MapControllers();

app.Run();

Development Experience with sharepoint, MVC, .net

Monday, October 27, 2025

DOT NET CORE

Blog Archive