public DataTable CloseConnections()
{
clsLog oLog = new clsLog();
DataTable table = null;
try
{
//if (this.TryConnection())
//{
oLog.WriteToDebugLogFile("executing Procedure", "CloseConnection");
DatabaseParameters parameters = new DatabaseParameters();
CurSQLFactory.ExecuteStoredProcedure(this.DataStructrure.StoredProcedures.closeConnections.ActualTableName, parameters);
table = CurDBEngine.SelectQuery(CurSQLFactory.SQL);
if (table == null)
{
error_occured = true;
ErrMsg = "[SwordfishManagerBase] : CloseConnections : " + CurDBEngine.ErrorMessage;
}
return(table);
//}
//error_occured = true;
//ErrMsg = "[SwordfishManagerBase] : CloseConnections : " + ErrMsg;
}
catch (Exception ex)
{
oLog.WriteToErrorLogFile(ex.Message.ToString(), "CloseConnection");
}
return(table);
}
public string DownloadMasterUsersByJSON(DateTime dtCreated)
{
UploadManager CurUploadManager = new UploadManager();
clsLog oLog = new clsLog();
oLog.WriteToDebugLogFile("Starting Function", "DownloadMasterUsersByJSON");
ApplicationUserCollection UserCollection = CurUploadManager.DownloadMasterUsersInColl(dtCreated);
// DataTable objDataSet = CurUploadManager.DownloadMasterUsers(dtCreated);
// Create a multidimensional jagged array
// string[][] JaggedArray = new string[objDataSet.Rows.Count][];
// int i = 0;
// foreach (DataRow rs in objDataSet.Rows)
// {
//JaggedArray[i] = new string[] { rs["user_id"].ToString(), rs["user_password"].ToString(), rs["user_firstname"].ToString() };
// i = i + 1;
//user.FirstName = ;
// }
// Return JSON data
string json = JsonConvert.SerializeObject(UserCollection);
return(json);
}
protected virtual bool TryConnection()
{
CloseConnections();
clsLog oLog = new clsLog();
try
{
if (!this.is_ready)
{
this.CurDBEngine = new DatabaseEngine(base.PrivateConfig.DatabaseType, base.PrivateConfig.DatabaseConnectionString);
if (this.CurDBEngine.Connect())
{
this.is_ready = true;
oLog.WriteToDebugLogFile("Connected", "TryConnection");
}
else
{
this.error_occured = true;
base.ErrMsg = this.CurDBEngine.ErrorMessage;
}
}
}
catch (Exception exception)
{
this.error_occured = true;
base.ErrMsg = exception.Message;
}
return(this.is_ready);
}
public string DownloadMasterCheckListType(DateTime dtCreated)
{
clsLog oLog = new clsLog();
oLog.WriteToDebugLogFile("Starting Function", "DownloadMasterCheckListType");
UploadManager CurUploadManager = new UploadManager();
MasterCheckListTypeCollection masterCheckListTypeColleaction = CurUploadManager.DownloadMasterCheckListType(dtCreated);
string json = JsonConvert.SerializeObject(masterCheckListTypeColleaction);
return(json);
}
public string DownloadQuickNotes()
{
clsLog oLog = new clsLog();
oLog.WriteToDebugLogFile("Starting Function", "DownloadQuickNotes");
UploadManager CurUploadManager = new UploadManager();
MasterQuickNotesCollection quickNotesCollection = CurUploadManager.DownloadQuickNotes();
string json = JsonConvert.SerializeObject(quickNotesCollection);
return(json);
}
public string DownloadMasterLookUp(DateTime dtCreated)
{
UploadManager CurUploadManager = new UploadManager();
clsLog oLog = new clsLog();
oLog.WriteToDebugLogFile("Starting Function", "DownloadMasterLookUp");
MasterLookUpCollection lookUpCollection = CurUploadManager.DownloadMasterLookUp(dtCreated);
string json = JsonConvert.SerializeObject(lookUpCollection);
return(json);
}
public string DownloadMasterCausesByJSON(DateTime dtCreated)
{
clsLog oLog = new clsLog();
oLog.WriteToDebugLogFile("Starting Function", "DownloadMasterCausesByJSON");
UploadManager CurUploadManager = new UploadManager();
MasterCauseCollection CausesCollection = CurUploadManager.DownloadMasterCauses(dtCreated);
string json = JsonConvert.SerializeObject(CausesCollection);
return(json);
}
public override void Dispose()
{
clsLog oLog = new clsLog();
oLog.WriteToDebugLogFile("Starting Function", "Dispose");
if (this.is_detroyable)
{
oLog.WriteToDebugLogFile("Before Destroy", "Dispose");
if (this.IsReady)
{
oLog.WriteToDebugLogFile("Before Disconnect", "Dispose");
if (CurDBEngine != null)
{
this.CurDBEngine.Disconnect();
oLog.WriteToDebugLogFile("After Disconnect", "Dispose");
}
else
{
oLog.WriteToDebugLogFile("DB Engine is Null", "Dispose");
}
}
this.CurDBEngine = null;
this.CurSQLFactory = null;
oLog.WriteToDebugLogFile("Ending Function", "Dispose");
}
}
public bool UploadOpNotificationByJSON(string json)
{
bool smooth = true;
clsLog oLog = new clsLog();
oLog.WriteToDebugLogFile("Starting Function", "UploadOpNotificationByJSON");
WebObjects.obj_notification[] CurOpNotificationCollection = JsonConvert.DeserializeObject <WebObjects.obj_notification[]>(json);
UploadManager CurUploadManager = new UploadManager();
smooth = CurUploadManager.UploadOpNotificationCollectionToSQLServer(CurOpNotificationCollection);
return(smooth);
}
public DataSet Get_InspectionQA_Project(DataSet oDTCompanyList, string sCompany, string sCurrentUserName, string sUserRole)
{
DataSet oDataset = new DataSet();
string sFuncName = string.Empty;
string sProcName = string.Empty;
DataView oDTView = new DataView();
try
{
sFuncName = "Get_InspectionQA_Project()";
sProcName = "AE_SP023_Mobile_INSQA_GetProject";
if (p_iDebugMode == DEBUG_ON)
{
oLog.WriteToDebugLogFile("Starting Function ", sFuncName);
}
if (p_iDebugMode == DEBUG_ON)
{
oLog.WriteToDebugLogFile("Calling Run_StoredProcedure() " + sProcName, sFuncName);
}
if (oDTCompanyList != null && oDTCompanyList.Tables.Count > 0)
{
oDTView = oDTCompanyList.Tables[0].DefaultView;
oDTView.RowFilter = "U_DBName= '" + sCompany + "'";
if (oDTView != null && oDTView.Count > 0)
{
oDataset = SqlHelper.ExecuteDataSet(oDTView[0]["U_ConnString"].ToString(), CommandType.StoredProcedure, sProcName,
Data.CreateParameter("@Company", sCompany), Data.CreateParameter("@UserName", sCurrentUserName), Data.CreateParameter("@UserRole", sUserRole));
if (p_iDebugMode == DEBUG_ON)
{
oLog.WriteToDebugLogFile("Completed With SUCCESS ", sFuncName);
}
}
else
{
if (p_iDebugMode == DEBUG_ON)
{
oLog.WriteToDebugLogFile("No Data in OUSR table for the selected Company", sFuncName);
}
return(oDataset);
}
}
else
{
if (p_iDebugMode == DEBUG_ON)
{
oLog.WriteToDebugLogFile("There is No Company List in the Holding Company ", sFuncName);
}
return(oDataset);
}
return(oDataset);
}
catch (Exception Ex)
{
sErrDesc = Ex.Message.ToString();
oLog.WriteToErrorLogFile(sErrDesc, sFuncName);
if (p_iDebugMode == DEBUG_ON)
{
oLog.WriteToDebugLogFile("Completed With ERROR ", sFuncName);
}
throw Ex;
}
}
public DataSet SPA_ValidateUser(string sUserName, string sPassword, string sCategory)
{
DataSet oDataset = new DataSet();
string sFuncName = string.Empty;
string sProcName = string.Empty;
DataView oDTView = new DataView();
try
{
sFuncName = "SPA_ValidateUser()";
sProcName = "AE_SPA001_Mobile_ValidateUser";
if (p_iDebugMode == DEBUG_ON)
{
oLog.WriteToDebugLogFile("Starting Function ", sFuncName);
}
if (p_iDebugMode == DEBUG_ON)
{
oLog.WriteToDebugLogFile("Calling Run_StoredProcedure() " + sProcName, sFuncName);
}
oDataset = SqlHelper.ExecuteDataSet(ConnectionString, CommandType.StoredProcedure, sProcName,
Data.CreateParameter("@UserName", sUserName), Data.CreateParameter("@Password", sPassword), Data.CreateParameter("@Category", sCategory));
if (p_iDebugMode == DEBUG_ON)
{
oLog.WriteToDebugLogFile("Completed With SUCCESS ", sFuncName);
}
if (oDataset.Tables.Count > 0 && oDataset != null)
{
if (p_iDebugMode == DEBUG_ON)
{
oLog.WriteToDebugLogFile("There is a set of data from the SP :" + sProcName, sFuncName);
}
return(oDataset);
}
else
{
if (p_iDebugMode == DEBUG_ON)
{
oLog.WriteToDebugLogFile("There is no data from the SP :" + sProcName, sFuncName);
}
return(oDataset);
}
}
catch (Exception Ex)
{
sErrDesc = Ex.Message.ToString();
oLog.WriteToErrorLogFile(sErrDesc, sFuncName);
if (p_iDebugMode == DEBUG_ON)
{
oLog.WriteToDebugLogFile("Completed With ERROR ", sFuncName);
}
throw Ex;
}
}
public DataSet Get_CompanyList()
{
DataSet oDataset;
string sFuncName = string.Empty;
string sProcName = string.Empty;
try
{
sFuncName = "Get_CompanyList()";
sProcName = "AE_SP001_Mobile_GetCompanyList";
if (p_iDebugMode == DEBUG_ON)
{
oLog.WriteToDebugLogFile("Starting Function ", sFuncName);
}
if (p_iDebugMode == DEBUG_ON)
{
oLog.WriteToDebugLogFile("Calling Run_StoredProcedure() " + sProcName, sFuncName);
}
oDataset = SqlHelper.ExecuteDataSet(ConnectionString, CommandType.StoredProcedure, "AE_SP001_Mobile_GetCompanyList");
if (p_iDebugMode == DEBUG_ON)
{
oLog.WriteToDebugLogFile("Completed With SUCCESS ", sFuncName);
}
return(oDataset);
}
catch (Exception Ex)
{
sErrDesc = Ex.Message.ToString();
oLog.WriteToErrorLogFile(sErrDesc, sFuncName);
if (p_iDebugMode == DEBUG_ON)
{
oLog.WriteToDebugLogFile("Completed With ERROR ", sFuncName);
}
throw Ex;
}
}
public void GetUserInfo(string sCompany)
{
DataTable dtResult = new DataTable();
string sResult = string.Empty;
try
{
oLog.WriteToDebugLogFile("Starting Function", sFuncName);
//sSQL = string.Format("call \"AE_SP001_UFF_Generation\" ('{0}')", sFileId);
sSQL = string.Format("call \"AE_SP001_GETALLUSERS\"");
oLog.WriteToDebugLogFile("Execute SQL" + sSQL, sFuncName);
OdbcParameter[] Param = new OdbcParameter[0];
dtResult = oCommon.ExecuteSQLQuery(sSQL, sCompany, Param);
List <Users> lstUsers = new List <Users>();
if (dtResult.Rows.Count > 0)
{
foreach (DataRow r in dtResult.Rows)
{
Users _company = new Users();
_company.USERCODE = r["USERCODE"].ToString();
_company.USERNAME = r["USERNAME"].ToString();
_company.DEFAULTENTITY = r["DEFAULTENTITY"].ToString();
_company.DEFAULTBRANCHCODE = r["DEFAULTBRANCHCODE"].ToString();
_company.DEFAULTDEPTCODE = r["DEFAULTDEPTCODE"].ToString();
_company.PASSWORD = r["PASSWORD"].ToString();
_company.LOCKED = r["LOCKED"].ToString();
_company.DEFAULTAPPROVALLEVEL = r["DEFAULTAPPROVALLEVEL"].ToString();
_company.APPROVALSCOPE = r["APPROVAL SCOPE"].ToString();
_company.LANGUAGE = r["LANGUAGE"].ToString();
lstUsers.Add(_company);
}
oLog.WriteToDebugLogFile("Before Serializing the Company List ", sFuncName);
Context.Response.Output.Write(js.Serialize(lstUsers));
oLog.WriteToDebugLogFile("After Serializing the Company List , the Serialized data is ' " + js.Serialize(lstUsers) + " '", sFuncName);
}
else
{
Context.Response.Output.Write(js.Serialize(lstUsers));
}
oLog.WriteToDebugLogFile("Ending Function", sFuncName);
}
catch (Exception ex)
{
sErrDesc = ex.Message.ToString();
oLog.WriteToErrorLogFile(sErrDesc, sFuncName);
oLog.WriteToDebugLogFile("Completed With ERROR ", sFuncName);
result objResult = new result();
objResult.Result = "Error";
objResult.DisplayMessage = sErrDesc;
lstResult.Add(objResult);
Context.Response.Output.Write(js.Serialize(lstResult));
}
}
/// <summary>
///
/// </summary>
/// <param name="from"></param>
/// <param name="to"></param>
/// <param name="subject"></param>
/// <param name="body"></param>
/// <param name="attachments"></param>
/// <returns></returns>
public static string SendEmail(string from, string[] tos, string subject, string body, Attachment[] attachments, string embeddedImage)
{
string sErrDesc = string.Empty;
string sFuncName = string.Empty;
const Int16 DEBUG_ON = 1;
clsLog oLog = new clsLog();
Int16 p_iDebugMode = DEBUG_ON;
try
{
sFuncName = "SendEmail";
var smtp = new System.Net.Mail.SmtpClient();
{
smtp.Host = System.Configuration.ConfigurationManager.AppSettings["SMTPServer"].ToString();
smtp.Port = int.Parse(System.Configuration.ConfigurationManager.AppSettings["SMTPPort"].ToString());;
smtp.EnableSsl = true;
smtp.DeliveryMethod = System.Net.Mail.SmtpDeliveryMethod.Network;
smtp.UseDefaultCredentials = false;
smtp.Credentials = new NetworkCredential(System.Configuration.ConfigurationManager.AppSettings["SMTPUser"].ToString(), System.Configuration.ConfigurationManager.AppSettings["SMTPPassword"].ToString());
smtp.Timeout = 900000;
}
MailMessage mail = new MailMessage();
if (embeddedImage != null)
{
AlternateView View;
LinkedResource resource;
View = AlternateView.CreateAlternateViewFromString(body.ToString(), null, "text/html");
resource = new LinkedResource(embeddedImage);
resource.ContentId = "Logo";
View.LinkedResources.Add(resource);
mail.AlternateViews.Add(View);
}
mail.From = new MailAddress(from);
foreach (string to in tos)
{
mail.To.Add(to);
}
string ccAddress = System.Configuration.ConfigurationManager.AppSettings["CCEmail"].ToString();
MailAddress cc = new MailAddress(ccAddress);
mail.CC.Add(cc);
mail.Subject = subject;
//mail.Body = body;
if (attachments != null)
{
foreach (Attachment attachment in attachments)
{
mail.Attachments.Add(attachment);
}
}
mail.Body = body;
mail.IsBodyHtml = true;
smtp.Send(mail);
return("Success");
}
catch (Exception ex)
{
sErrDesc = ex.Message.ToString();
oLog.WriteToErrorLogFile(sErrDesc, sFuncName);
if (p_iDebugMode == DEBUG_ON)
{
oLog.WriteToDebugLogFile("Completed With ERROR", sFuncName);
}
return(ex.Message);
}
}
public DataSet SPA_DashboardInfo(string sAppType, string sUserCode)
{
DataSet oDataset = new DataSet();
string sFuncName = string.Empty;
string sProcName = string.Empty;
DataView oDTView = new DataView();
try
{
sFuncName = "SPA_DashboardInfo()";
sProcName = "AE_SPA002_Mobile_GetDashboardInfo";
if (p_iDebugMode == DEBUG_ON)
{
oLog.WriteToDebugLogFile("Starting Function ", sFuncName);
}
if (p_iDebugMode == DEBUG_ON)
{
oLog.WriteToDebugLogFile("Calling Run_StoredProcedure() " + sProcName, sFuncName);
}
oDataset = SqlHelper.ExecuteDataSet(ConnectionString, CommandType.StoredProcedure, sProcName,
Data.CreateParameter("@AppType", sAppType), Data.CreateParameter("@UserCode", sUserCode), Data.CreateParameter("@currentDate", DateTime.Now.Date));
if (p_iDebugMode == DEBUG_ON)
{
oLog.WriteToDebugLogFile("Completed With SUCCESS ", sFuncName);
}
if (oDataset.Tables.Count > 0 && oDataset != null)
{
if (p_iDebugMode == DEBUG_ON)
{
oLog.WriteToDebugLogFile("There is a set of data from the SP :" + sProcName, sFuncName);
}
return(oDataset);
}
else
{
if (p_iDebugMode == DEBUG_ON)
{
oLog.WriteToDebugLogFile("There is no data from the SP :" + sProcName, sFuncName);
}
return(oDataset);
}
}
catch (Exception Ex)
{
sErrDesc = Ex.Message.ToString();
oLog.WriteToErrorLogFile(sErrDesc, sFuncName);
if (p_iDebugMode == DEBUG_ON)
{
oLog.WriteToDebugLogFile("Completed With ERROR ", sFuncName);
}
throw Ex;
}
}
public DataSet Get_BitMapPath(DataSet oDTCompanyList, string sCompany)
{
DataSet oDataset = new DataSet();
string sFuncName = string.Empty;
string sQuery = string.Empty;
DataView oDTView = new DataView();
try
{
sFuncName = "Get_BitMapPath()";
sQuery = "select BitmapPath from OADP";
if (p_iDebugMode == DEBUG_ON)
{
oLog.WriteToDebugLogFile("Starting Function ", sFuncName);
}
if (p_iDebugMode == DEBUG_ON)
{
oLog.WriteToDebugLogFile("Calling SQLQuery " + sQuery, sFuncName);
}
if (oDTCompanyList != null && oDTCompanyList.Tables.Count > 0)
{
oDTView = oDTCompanyList.Tables[0].DefaultView;
oDTView.RowFilter = "U_DBName= '" + sCompany + "'";
if (oDTView != null && oDTView.Count > 0)
{
oDataset = SqlHelper.ExecuteDataSet(oDTView[0]["U_ConnString"].ToString(), CommandType.Text, sQuery);
if (p_iDebugMode == DEBUG_ON)
{
oLog.WriteToDebugLogFile("Completed With SUCCESS ", sFuncName);
}
}
else
{
if (p_iDebugMode == DEBUG_ON)
{
oLog.WriteToDebugLogFile("No Data in OUSR table for the selected Company", sFuncName);
}
return(oDataset);
}
}
else
{
if (p_iDebugMode == DEBUG_ON)
{
oLog.WriteToDebugLogFile("There is No Company List in the Holding Company ", sFuncName);
}
return(oDataset);
}
return(oDataset);
}
catch (Exception Ex)
{
sErrDesc = Ex.Message.ToString();
oLog.WriteToErrorLogFile(sErrDesc, sFuncName);
if (p_iDebugMode == DEBUG_ON)
{
oLog.WriteToDebugLogFile("Completed With ERROR ", sFuncName);
}
throw Ex;
}
}