/// <summary>
/// Save Data To Database
/// <para>Use it when save data through a stored procedure</para>
/// </summary>
public int UpdateOrganogram(CmnOrganogram model)
{
GenericFactoryFor_Organogram = new vmCmnOrganogram_GF();
int result = 0;
try
{
Hashtable ht = new Hashtable();
ht.Add("OrganogramID", model.OrganogramID);
ht.Add("CustomCode", model.CustomCode);
ht.Add("OrganogramName", model.OrganogramName);
ht.Add("ParentID", model.ParentID);
//ht.Add("IsCostCenter", model.IsCostCenter);
//ht.Add("IsDefault", model.IsDefault);
//ht.Add("StatusID", model.StatusID);
ht.Add("CompanyID", model.CompanyID);
ht.Add("CreateBy", model.CreateBy);
ht.Add("CreateOn", DateTime.Now);
ht.Add("CreatePc", HostService.GetIP());
ht.Add("UpdateBy", 1);
ht.Add("UpdateOn", DateTime.Now);
ht.Add("UpdatePc", HostService.GetIP());
ht.Add("IsDeleted", model.IsDeleted);
ht.Add("DeleteBy", model.DeleteBy);
ht.Add("DeleteOn", model.DeleteOn);
ht.Add("DeletePc", model.DeletePc);
string spQuery = "[Put_CmnOrganogram]";
result = GenericFactoryFor_Organogram.ExecuteCommand(spQuery, ht);
}
catch (Exception e)
{
e.ToString();
}
return(result);
}
/// <summary>
/// Save Data To Database
/// <para>Use it when save data through ORM</para>
/// </summary>
public int SaveStockEntry(InvStockMaster model)
{
GenericFactory_EF_StockItems = new InvStockMaster_GF();
int result = 0;
string spQuery = "";
Hashtable ht = new Hashtable();
try
{
model.CreateOn = DateTime.Today;
model.CreatePc = HostService.GetIP();
model.IsDeleted = false;
ht.Add("ItemID", model.ItemID);
ht.Add("GradeID", model.GradeID);
ht.Add("Qty", model.ReceiveQty);
ht.Add("CompanyID", model.CompanyID);
spQuery = "[Put_CmnInvStockMaster]";
result = GenericFactory_EF_StockItems.ExecuteCommand(spQuery, ht);
}
catch (Exception ex)
{
ex.ToString();
}
return(result);
}
/// <summary>
/// Save Data To Database
/// <para>Use it when save data through a stored procedure</para>
/// </summary>
public int UpdateUserGroup(vmUserGroup model)
{
int result = 0;
try
{
if (model != null)
{
using (GenericFactoryFor_UserGroup = new vmUserGroup_GF())
{
Hashtable ht = new Hashtable();
ht.Add("CompanyID", model.CompanyID);
ht.Add("LoggedUser", model.LoggedUser);
ht.Add("UserGroupID", model.UserGroupID);
ht.Add("GroupName", model.GroupName);
ht.Add("Sequence", model.Sequence);
string spQuery = "[Put_CmnUserGroup]";
result = GenericFactoryFor_UserGroup.ExecuteCommand(spQuery, ht);
}
}
}
catch (Exception e)
{
e.ToString();
}
return(result);
}
/// <summary>
/// Update Delete From Database
/// <para>Use it when delete data through a stored procedure</para>
/// </summary>
public int DeleteUserType(int?id, int?CompanyID, int?LoggedUser)
{
int result = 0;
try
{
if ((id > 0) && (CompanyID > 0))
{
using (GenericFactoryFor_UserType = new vmUserType_GF())
{
Hashtable ht = new Hashtable();
ht.Add("CompanyID", CompanyID);
ht.Add("LoggedUser", LoggedUser);
ht.Add("UserTypeID", id);
string spQuery = "[Delete_CmnUserType]";
result = GenericFactoryFor_UserType.ExecuteCommand(spQuery, ht);
}
}
}
catch (Exception e)
{
e.ToString();
}
return(result);
}
/// <summary>
/// Save Data To Database
/// <para>Use it when save data through a stored procedure</para>
/// </summary>
public int UpdateUserType(vmUserType model)
{
int result = 0;
try
{
if (model != null)
{
using (GenericFactoryFor_UserType = new vmUserType_GF())
{
Hashtable ht = new Hashtable();
ht.Add("CompanyID", model.CompanyID);
ht.Add("LoggedUser", model.LoggedUser);
ht.Add("UserTypeID", model.UserTypeID);
ht.Add("UserTypeName", model.UserTypeName);
ht.Add("ParentID", model.ParentID);
string spQuery = "[Put_CmnUserType]";
result = GenericFactoryFor_UserType.ExecuteCommand(spQuery, ht);
}
}
}
catch (Exception e)
{
e.ToString();
}
return(result);
}
/// <summary>
/// Save Data To Database
/// <para>Use it when save data through a stored procedure</para>
/// </summary>
public int UpdateCompany(CmnCompany model, UserCommonEntity commonEntity)
{
GenericFactoryFor_Company = new CmnCompany_GF();
int result = 0;
try
{
Hashtable ht = new Hashtable();
ht.Add("CompanyID", model.CompanyID);
ht.Add("CustomCode", model.CustomCode);
ht.Add("CompanyShortName", model.CompanyShortName);
ht.Add("CompanyName", model.CompanyName);
ht.Add("LoggedCompanyID", commonEntity.loggedCompnyID);
ht.Add("LoggedUser", commonEntity.loggedUserID);
string spQuery = "[Put_CmnCompany]";
result = GenericFactoryFor_Company.ExecuteCommand(spQuery, ht);
}
catch (Exception ex)
{
ErrorLog.Log(ex);
ex.ToString();
}
return(result);
}
/// <summary>
/// Save Data To Database
/// <para>Use it when save data through a stored procedure</para>
/// </summary>
public int SaveEmployee(EmpMaster model)
{
int result = 0;
try
{
Hashtable ht = new Hashtable();
ht.Add("EmpName", model.EmpName);
string spQuery = "[Set_Customer]";
result = GenericFactoryFor_Emp.ExecuteCommand(spQuery, ht);
}
catch (Exception e)
{
e.ToString();
}
return(result);
}
/// <summary>
/// Save Data To Database
/// <para>Use it when save data through a stored procedure</para>
/// </summary>
public int SaveCustomer(tbl_Customer model)
{
int result = 0;
try
{
Hashtable ht = new Hashtable();
ht.Add("Name", model.Name);
ht.Add("Email", model.Email);
ht.Add("Mobile", model.Mobile);
string spQuery = "[Set_Customer]";
result = GenericFactoryFor_Customer.ExecuteCommand(spQuery, ht);
}
catch (Exception e)
{
e.ToString();
}
return(result);
}
/// <summary>
/// Save Data To Database
/// <para>Use it when save data through a stored procedure</para>
/// </summary>
public int SaveCompany(CmnCompany model)
{
GenericFactoryEF_Company = new CmnCompany_EF();
GFactory_EF_CmnCustomCode = new SalCmnCustomCode_EF();
int result = 0;
try
{
#region CustomCode And Primary Key Process
int NextId = Convert.ToInt16(GenericFactoryEF_Company.getMaxID("CmnCompany"));
model.CompanyID = NextId;
//......... START for custom code........... //
//string customCode = "";
CmnCustomCode objCustomCode = GFactory_EF_CmnCustomCode.FindBy(m => m.MenuID == model.MenuID && m.IsDeleted == false).FirstOrDefault();
//int customCodeID = Convert.ToInt16(objCustomCode.RecordID);
//if (customCodeID > 0)
//{
// // customCode = GenericFactory_EF_SalPIMaster.getCustomCode(customCodeID, DateTime.Now, itemMaster.CompanyID, 1, 1);
// customCode = GFactory_EF_CmnCustomCode.getCustomCode(customCodeID, DateTime.Now, 0, 1, 1);
//}
//else
//{
// customCode = NextId.ToString();
//}
//.........END for custom code............ //
#endregion CustomCode And Primary Key Process
Hashtable ht = new Hashtable();
ht.Add("CompanyID", model.CompanyID);
ht.Add("CustomCode", model.CustomCode);
ht.Add("CompanyShortName", model.CompanyShortName);
ht.Add("CompanyName", model.CompanyName);
//ht.Add("StatusID", model.StatusID);
string spQuery = "[Set_CmnCompany]";
result = GenericFactoryFor_Company.ExecuteCommand(spQuery, ht);
//Update Primary Key and Custom Code
GenericFactoryEF_Company.updateMaxID("CmnCompany", Convert.ToInt64(NextId));
//GFactory_EF_CmnCustomCode.updateCustomCode(customCodeID, DateTime.Now, 0, 1, 1);
}
catch (Exception ex)
{
ErrorLog.Log(ex);
ex.ToString();
}
return(result);
}
/// Static ID Provided
/// <summary>
/// Save Data To Database
/// <para>Use it when save data through a stored procedure</para>
/// </summary>
public int SaveMenu(CmnMenu model)
{
GenericFactoryFor_Menu = new vmCmnMenu_GF();
int result = 0;
try
{
Hashtable ht = new Hashtable();
ht.Add("MenuID", model.MenuID);
ht.Add("CustomCode", model.CustomCode);
ht.Add("MenuName", model.MenuName);
ht.Add("ModuleID", model.ModuleID);
ht.Add("MenuPath", model.MenuPath);
ht.Add("ReportName", model.ReportName);
ht.Add("ReportPath", model.ReportPath);
ht.Add("ParentID", model.ParentID);
ht.Add("Sequence", model.Sequence);
ht.Add("MenuTypeID", model.MenuTypeID);
ht.Add("StatusID", model.StatusID);
ht.Add("MenuIconCss", model.MenuIconCss);
ht.Add("CompanyID", model.CompanyID);
ht.Add("CreateBy", 1);
ht.Add("CreateOn", DateTime.Now);
ht.Add("CreatePc", HostService.GetIP());
ht.Add("UpdateBy", model.UpdateBy);
ht.Add("UpdateOn", model.UpdateOn);
ht.Add("UpdatePc", model.UpdatePc);
ht.Add("IsDeleted", model.IsDeleted);
ht.Add("DeleteBy", model.DeleteBy);
ht.Add("DeleteOn", model.DeleteOn);
ht.Add("DeletePc", model.DeletePc);
string spQuery = "[Set_CmnMenu]";
result = GenericFactoryFor_Menu.ExecuteCommand(spQuery, ht);
}
catch (Exception e)
{
e.ToString();
}
return(result);
}
/// <summary>
/// Update Delete From Database
/// <para>Use it when delete data through a stored procedure</para>
/// </summary>
public int DeleteModule(int?ModuleID)
{
GenericFactoryFor_Module = new vmCmnModule_GF();
int result = 0;
try
{
Hashtable ht = new Hashtable();
ht.Add("ModuleID", ModuleID);
string spQuery = "[Delete_CmnModule]";
result = GenericFactoryFor_Module.ExecuteCommand(spQuery, ht);
}
catch (Exception e)
{
e.ToString();
}
return(result);
}
/// <summary>
/// Save Data To Database
/// <para>Use it when save data through a stored procedure</para>
/// </summary>
public int SaveErrorLog(vmErrorStack model)
{
int result = 0;
try
{
Hashtable ht = new Hashtable();
ht.Add("tblErrorLog", model);
string spQuery = "[Set_AppErrorLog]";
result = GenericFactoryFor_Error.ExecuteCommand(spQuery, ht);
}
catch (Exception ex)
{
result = 0;
ErrorLog.Log(ex);
ex.ToString();
}
return(result);
}
/// Static ID Provided
/// <summary>
/// Save Data To Database
/// <para>Use it when save data through a stored procedure</para>
/// </summary>
public int SaveModule(CmnModule model)
{
GenericFactoryFor_Module = new vmCmnModule_GF();
int result = 0;
try
{
Hashtable ht = new Hashtable();
ht.Add("ModuleID", model.ModuleID);
ht.Add("CustomCode", model.CustomCode);
ht.Add("ModuleName", model.ModuleName);
ht.Add("Description", model.Description);
ht.Add("Sequence", model.Sequence);
ht.Add("ImageURL", model.ImageURL);
ht.Add("ModulePath", model.ModulePath);
ht.Add("StatusID", 1);
ht.Add("CompanyID", model.CompanyID);
ht.Add("CreateBy", 1);
ht.Add("CreateOn", DateTime.Now);
ht.Add("CreatePc", HostService.GetIP());
ht.Add("UpdateBy", model.UpdateBy);
ht.Add("UpdateOn", model.UpdateOn);
ht.Add("UpdatePc", model.UpdatePc);
ht.Add("IsDeleted", model.IsDeleted);
ht.Add("DeleteBy", model.DeleteBy);
ht.Add("DeleteOn", model.DeleteOn);
ht.Add("DeletePc", model.DeletePc);
string spQuery = "[Set_CmnModule]";
result = GenericFactoryFor_Module.ExecuteCommand(spQuery, ht);
}
catch (Exception e)
{
e.ToString();
}
return(result);
}
/// <summary>
/// Update Delete From Database
/// <para>Use it when delete data through a stored procedure</para>
/// </summary>
public int DeleteCompany(int?CompanyID, UserCommonEntity commonEntity)
{
GenericFactoryFor_Company = new CmnCompany_GF();
int result = 0;
try
{
Hashtable ht = new Hashtable();
ht.Add("CompanyID", CompanyID);
ht.Add("LoggedCompanyID", commonEntity.loggedCompnyID);
ht.Add("LoggedUser", commonEntity.loggedUserID);
string spQuery = "[Delete_CmnCompany]";
result = GenericFactoryFor_Company.ExecuteCommand(spQuery, ht);
}
catch (Exception ex)
{
ErrorLog.Log(ex);
ex.ToString();
}
return(result);
}
/// <summary>
/// Save Data To Database
/// <para>Use it when save data through a stored procedure</para>
/// </summary>
public int SaveCompanyParam(CmnCompany model, UserCommonEntity commonEntity)
{
GenericFactoryFor_Company = new CmnCompany_GF();
GenericFactoryEF_Company = new CmnCompany_EF();
GFactory_EF_CmnCustomCode = new SalCmnCustomCode_EF();
int result = 0;
try
{
#region CustomCode And Primary Key Process
int NextId = Convert.ToInt16(GenericFactoryEF_Company.getMaxID("CmnCompany"));
model.CompanyID = NextId;
//......... START for custom code........... //
//string customCode = "";
CmnCustomCode objCustomCode = GFactory_EF_CmnCustomCode.FindBy(m => m.MenuID == model.MenuID && m.IsDeleted == false).FirstOrDefault();
//int customCodeID = Convert.ToInt16(objCustomCode.RecordID);
//if (customCodeID > 0)
//{
// // customCode = GenericFactory_EF_SalPIMaster.getCustomCode(customCodeID, DateTime.Now, itemMaster.CompanyID, 1, 1);
// customCode = GFactory_EF_CmnCustomCode.getCustomCode(customCodeID, DateTime.Now, 0, 1, 1);
//}
//else
//{
// customCode = NextId.ToString();
//}
//.........END for custom code............ //
#endregion CustomCode And Primary Key Process
#region Basic Save
Hashtable ht = new Hashtable();
ht.Add("CompanyID", model.CompanyID);
ht.Add("CustomCode", model.CustomCode);
ht.Add("CompanyShortName", model.CompanyShortName);
ht.Add("CompanyName", model.CompanyName);
ht.Add("LoggedCompanyID", commonEntity.loggedCompnyID);
ht.Add("LoggedUser", commonEntity.loggedUserID);
// ht.Add("StatusID", model.StatusID);
string spQuery = "[Set_CmnCompany]";
result = GenericFactoryFor_Company.ExecuteCommand(spQuery, ht);
#endregion Basic Save
#region WorkFlow Transaction Entry
//// CHECK WorkFLow Setup
////IF targetUserID=0 Then Work flow is not configured
//int targetUserID = new WorkFLowMgt().GetWorkFlowBeginner(commonEntity);
//if (targetUserID > 0)
//{
// //IN CASE OF SAVE
// //REQUIRD MENUID, COMPANYID, TARGET USERID AS TARGET USERID, USER AS CURRENT USERID,TRANSACTION ID AS MASTERID(INSERTED) ,STATUSID 1
// //IS APPROVED 0, IS DELETE 0, IS UPDATE 0 , @APPROVALCUSTOMCODE = '',Is Declained=0
// var comment = "";
// var APPROVALCUSTOMCODE = string.Empty;
// // int WorkFlowStatus = new WorkFLowMgt().ExecuteWorkFlowTransactionProcess(new WorkFLowMgt().SetProcedureParam(commonEntity, targetUserID, NextId, 0, comment, 0, 0, 1, "", 0));
// String MessageName = System.Enum.GetName(typeof(workFlowTranEnum_MessageName), (int)workFlowTranEnum_MessageName.Created);
// int WorkFlowStatus = new WorkFLowMgt().ExecuteWorkFlowTransactionProcess(new WorkFLowMgt().SetProcedureParam(commonEntity, targetUserID, NextId, (int)workFlowTranEnum_IsApproved.False, comment, (int)workFlowTranEnum_IsUpdate.False, (int)workFlowTranEnum_IsDelete.False, (int)workFlowTranEnum_Status.Active, APPROVALCUSTOMCODE, (int)workFlowTranEnum_IsDeclained.False, MessageName));
//}
#endregion WorkFlow Transaction Entry
#region CustomCode And Primary Key Process Update Process
//Update Primary Key and Custom Code
GenericFactoryEF_Company.updateMaxID("CmnCompany", Convert.ToInt64(NextId));
// GFactory_EF_CmnCustomCode.updateCustomCode(customCodeID, DateTime.Now, 0, 1, 1);
#endregion CustomCode And Primary Key Process Update Process
#region WorkFlow Transaction Entry Team
int workflowID = 0;
List <vmCmnWorkFlowMaster> listWorkFlow = new WorkFLowMgt().GetWorkFlowMasterListByMenu(commonEntity);
foreach (vmCmnWorkFlowMaster item in listWorkFlow)
{
int userTeamID = item.UserTeamID ?? 0;
if (new WorkFLowMgt().checkUserValidation(commonEntity.loggedUserID ?? 0, item.WorkFlowID) && userTeamID > 0)
{
item.WorkFlowTranCustomID = model.CompanyID;
workflowID = new WorkFLowMgt().ExecuteTransactionProcess(item, commonEntity);
//Mail Service
}
if (userTeamID == 0)
{
item.WorkFlowTranCustomID = model.CompanyID;
workflowID = new WorkFLowMgt().ExecuteTransactionProcess(item, commonEntity);
}
}
#endregion Workflow Transaction Enltry Team
}
catch (Exception)
{
throw new Exception();
}
return(result);
}
