/// <summary>
/// Create Store Hierarchy
/// </summary>
/// <param name="customHierarchymodel"></param>
/// <param name=""></param>
/// <returns></returns>
public int CreateStoreHierarchy(CustomHierarchymodel customHierarchymodel)
{
int Success = 0;
try
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("SP_CreateStoreHierarchy", conn)
{
Connection = conn,
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.AddWithValue("@Designation_Name", customHierarchymodel.DesignationName);
cmd.Parameters.AddWithValue("@Reportto_ID", customHierarchymodel.ReportToDesignation);
cmd.Parameters.AddWithValue("@Is_Active", customHierarchymodel.IsActive);
cmd.Parameters.AddWithValue("@Tenant_ID", customHierarchymodel.TenantID);
cmd.Parameters.AddWithValue("@User_ID", customHierarchymodel.CreatedBy);
Success = Convert.ToInt32(cmd.ExecuteScalar());
}
catch (Exception)
{
throw;
}
finally
{
if (conn != null)
{
conn.Close();
}
}
return(Success);
}
/// <summary>
/// Update Store Hierarchy
/// </summary>
/// <param name="customHierarchymodel"></param>
/// <param name=""></param>
/// <returns></returns>
public int UpdateStoreHierarchy(CustomHierarchymodel customHierarchymodel)
{
int success = 0;
try
{
conn.Open();
MySqlCommand cmd = new MySqlCommand
{
Connection = conn,
CommandType = CommandType.StoredProcedure,
CommandText = "SP_UpdateStoreHierarchy"
};
cmd.Parameters.AddWithValue("@Designation_ID", customHierarchymodel.DesignationID);
cmd.Parameters.AddWithValue("@Designation_Name", string.IsNullOrEmpty(customHierarchymodel.DesignationName) ? "" : customHierarchymodel.DesignationName);
cmd.Parameters.AddWithValue("@Reportto_ID", string.IsNullOrEmpty(Convert.ToString(customHierarchymodel.ReportToDesignation)) ? 0 : customHierarchymodel.ReportToDesignation);
cmd.Parameters.AddWithValue("@Is_Active", customHierarchymodel.IsActive);
cmd.Parameters.AddWithValue("@Tenant_ID", customHierarchymodel.TenantID);
cmd.Parameters.AddWithValue("@User_ID", customHierarchymodel.CreatedBy);
success = Convert.ToInt32(cmd.ExecuteScalar());
}
catch (Exception)
{
throw;
}
finally
{
if (conn != null)
{
conn.Close();
}
}
return(success);
}
public ResponseModel CreateHierarchy([FromBody] CustomHierarchymodel customHierarchymodel)
{
HierarchyCaller hierarchy = new HierarchyCaller();
ResponseModel objResponseModel = new ResponseModel();
int statusCode = 0;
string statusMessage = "";
try
{
string token = Convert.ToString(Request.Headers["X-Authorized-Token"]);
Authenticate authenticate = new Authenticate();
authenticate = SecurityService.GetAuthenticateDataFromTokenCache(Cache, SecurityService.DecryptStringAES(token));
customHierarchymodel.TenantID = authenticate.TenantId;
customHierarchymodel.CreatedBy = authenticate.UserMasterID;
int result = hierarchy.CreateHierarchy(new HierarchyService(Cache, Db), customHierarchymodel);
if (customHierarchymodel.Deleteflag == 1)
{
if (result == 0)
{
statusMessage = "Record in use";
}
else
{
statusMessage = "Record deleted successfully ";
}
statusCode =
result == 0 ? (int)EnumMaster.StatusCode.RecordInUse : (int)EnumMaster.StatusCode.RecordDeletedSuccess;
}
if (customHierarchymodel.DesignationID == 0)
{
if (result == 0)
{
statusCode =
result == 0 ?
(int)EnumMaster.StatusCode.RecordAlreadyExists : (int)EnumMaster.StatusCode.Success;
}
else
{
statusCode = result > 0 ? (int)EnumMaster.StatusCode.Success : (int)EnumMaster.StatusCode.RecordNotFound;
}
}
else
{
statusCode =
result == 0 ?
(int)EnumMaster.StatusCode.RecordNotFound : (int)EnumMaster.StatusCode.Success;
}
statusMessage = CommonFunction.GetEnumDescription((EnumMaster.StatusCode)statusCode);
objResponseModel.Status = true;
objResponseModel.StatusCode = statusCode;
objResponseModel.Message = statusMessage;
objResponseModel.ResponseData = result;
}
catch (Exception)
{
throw;
}
return(objResponseModel);
}
public ResponseModel UpdateStoreHierarchy([FromBody] CustomHierarchymodel customHierarchymodel)
{
StoreHierarchyCaller storeHierarchyCaller = new StoreHierarchyCaller();
ResponseModel objResponseModel = new ResponseModel();
int statusCode = 0;
string statusMessage = "";
try
{
string token = Convert.ToString(Request.Headers["X-Authorized-Token"]);
Authenticate authenticate = new Authenticate();
authenticate = SecurityService.GetAuthenticateDataFromToken(_radisCacheServerAddress, SecurityService.DecryptStringAES(token));
customHierarchymodel.TenantID = authenticate.TenantId;
customHierarchymodel.CreatedBy = authenticate.UserMasterID;
int result = storeHierarchyCaller.UpdateStoreHierarchy(new StoreHierarchyService(_connectionSting), customHierarchymodel);
statusCode =
result == 0 ?
(int)EnumMaster.StatusCode.RecordAlreadyExists : (int)EnumMaster.StatusCode.Success;
statusMessage = CommonFunction.GetEnumDescription((EnumMaster.StatusCode)statusCode);
objResponseModel.Status = true;
objResponseModel.StatusCode = statusCode;
objResponseModel.Message = statusMessage;
objResponseModel.ResponseData = result;
}
catch (Exception)
{
throw;
}
return(objResponseModel);
}
/// <summary>
/// List Store Hierarchy
/// </summary>
/// <param name="TenantID"></param>
/// <param name=""></param>
/// <returns></returns>
public List <CustomHierarchymodel> ListStoreHierarchy(int tenantID)
{
DataSet ds = new DataSet();
List <CustomHierarchymodel> listHierarchy = new List <CustomHierarchymodel>();
try
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("SP_ListStoreHierarchy", conn)
{
Connection = conn
};
cmd.Parameters.AddWithValue("@Tenant_ID", tenantID);
cmd.CommandType = CommandType.StoredProcedure;
MySqlDataAdapter da = new MySqlDataAdapter
{
SelectCommand = cmd
};
da.Fill(ds);
if (ds != null && ds.Tables[0] != null)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
CustomHierarchymodel hierarchymodel = new CustomHierarchymodel();
hierarchymodel.DesignationID = ds.Tables[0].Rows[i]["DesignationID"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i]["DesignationID"]);
hierarchymodel.DesignationName = ds.Tables[0].Rows[i]["DesignationName"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["DesignationName"]);
hierarchymodel.ReportTo = ds.Tables[0].Rows[i]["ReportTo"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["ReportTo"]);
hierarchymodel.Createdbyperson = ds.Tables[0].Rows[i]["Createdby"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["Createdby"]);
hierarchymodel.Updatedbyperson = ds.Tables[0].Rows[i]["UpdatedBy"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["UpdatedBy"]);
hierarchymodel.Status = ds.Tables[0].Rows[i]["IsActive"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["IsActive"]);
hierarchymodel.Createdateformat = ds.Tables[0].Rows[i]["CreatedDate"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["CreatedDate"]);
hierarchymodel.Updateddateformat = ds.Tables[0].Rows[i]["ModifiedDate"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["ModifiedDate"]);
hierarchymodel.ReportToDesignation = ds.Tables[0].Rows[i]["ReportToDesignation"] == DBNull.Value ? 0 : Convert.ToInt16(ds.Tables[0].Rows[i]["ReportToDesignation"]);
listHierarchy.Add(hierarchymodel);
}
}
}
catch (Exception)
{
throw;
}
finally
{
if (conn != null)
{
conn.Close();
}
}
return(listHierarchy);
}
public List <CustomHierarchymodel> ListHierarchy(int TenantID, int HierarchyFor)
{
DataSet ds = new DataSet();
List <CustomHierarchymodel> listHierarchy = new List <CustomHierarchymodel>();
try
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("SP_ListHierarchy", conn);
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@Tenant_ID", TenantID);
cmd.Parameters.AddWithValue("@Hierarchy_For", HierarchyFor);
cmd.CommandType = CommandType.StoredProcedure;
MySqlDataAdapter da = new MySqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds);
if (ds != null && ds.Tables[0] != null)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
CustomHierarchymodel hierarchymodel = new CustomHierarchymodel();
hierarchymodel.DesignationID = Convert.ToInt32(ds.Tables[0].Rows[i]["DesignationID"]);
hierarchymodel.DesignationName = Convert.ToString(ds.Tables[0].Rows[i]["DesignationName"]);
hierarchymodel.ReportTo = Convert.ToString(ds.Tables[0].Rows[i]["ReportTo"]);
hierarchymodel.Createdbyperson = Convert.ToString(ds.Tables[0].Rows[i]["Createdby"]);
hierarchymodel.Updatedbyperson = Convert.ToString(ds.Tables[0].Rows[i]["UpdatedBy"]);
hierarchymodel.Status = Convert.ToString(ds.Tables[0].Rows[i]["IsActive"]);
hierarchymodel.Createddate = Convert.ToDateTime(ds.Tables[0].Rows[i]["CreatedDate"]);
hierarchymodel.Createdateformat = hierarchymodel.Createddate.ToString("dd MMMM yyyy");
hierarchymodel.Updateddate = Convert.ToDateTime(ds.Tables[0].Rows[i]["ModifiedDate"]);
hierarchymodel.Updateddateformat = hierarchymodel.Updateddate.ToString("dd MMMM yyyy");
hierarchymodel.ReportToDesignation = Convert.ToInt16(ds.Tables[0].Rows[i]["ReportToDesignation"]);
listHierarchy.Add(hierarchymodel);
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (conn != null)
{
conn.Close();
}
}
return(listHierarchy);
}
/// <summary>
/// Create Hierarchy /update /soft delete
/// </summary>
/// <param name=""></param>
/// <param name=""></param>
/// <returns></returns>
public int CreateHierarchy(IHierarchy Hierarchy, CustomHierarchymodel customHierarchymodel)
{
_HierarchyRepository = Hierarchy;
return(_HierarchyRepository.CreateHierarchy(customHierarchymodel));
}
public int CreateHierarchy(CustomHierarchymodel customHierarchymodel)
{
int Success = 0;
if (customHierarchymodel.DesignationID == 0)
{
try
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("SP_CreateHierarchy", conn);
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Designation_Name", customHierarchymodel.DesignationName);
cmd.Parameters.AddWithValue("@Reportto_ID", customHierarchymodel.ReportToDesignation);
cmd.Parameters.AddWithValue("@Is_Active", customHierarchymodel.IsActive);
cmd.Parameters.AddWithValue("@Tenant_ID", customHierarchymodel.TenantID);
cmd.Parameters.AddWithValue("@User_ID", customHierarchymodel.CreatedBy);
cmd.Parameters.AddWithValue("@Hierarchy_For", customHierarchymodel.HierarchyFor);
Success = Convert.ToInt32(cmd.ExecuteScalar());
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (conn != null)
{
conn.Close();
}
}
}
if (customHierarchymodel.DesignationID > 0)
{
try
{
conn.Open();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
if (customHierarchymodel.Deleteflag != 1)
{
cmd.CommandText = "SP_UpdateHierarchy";
////Update
cmd.Parameters.AddWithValue("@Designation_ID", customHierarchymodel.DesignationID);
cmd.Parameters.AddWithValue("@Designation_Name", string.IsNullOrEmpty(customHierarchymodel.DesignationName) ? "" : customHierarchymodel.DesignationName);
cmd.Parameters.AddWithValue("@Reportto_ID", string.IsNullOrEmpty(Convert.ToString(customHierarchymodel.ReportToDesignation)) ? 0 : customHierarchymodel.ReportToDesignation);
cmd.Parameters.AddWithValue("@Is_Active", customHierarchymodel.IsActive);
cmd.Parameters.AddWithValue("@Tenant_ID", customHierarchymodel.TenantID);
cmd.Parameters.AddWithValue("@User_ID", customHierarchymodel.CreatedBy);
cmd.Parameters.AddWithValue("@Hierarchy_For", customHierarchymodel.HierarchyFor);
cmd.Parameters.AddWithValue("@Delete_flag", customHierarchymodel.Deleteflag);
}
else
{
////Delete the record
cmd.CommandText = "SP_DeleteHierarchy";
cmd.Parameters.AddWithValue("@Hierarchy_ID", customHierarchymodel.DesignationID);
cmd.Parameters.AddWithValue("@Tenant_ID", customHierarchymodel.TenantID);
}
Success = Convert.ToInt32(cmd.ExecuteNonQuery());
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (conn != null)
{
conn.Close();
}
}
}
return(Success);
}
/// <summary>
/// Update Store Hierarchy
/// </summary>
/// <param name="customHierarchymodel"></param>
/// <param name=""></param>
/// <returns></returns>
public int UpdateStoreHierarchy(IStoreHierarchy Hierarchy, CustomHierarchymodel customHierarchymodel)
{
_HierarchyRepository = Hierarchy;
return(_HierarchyRepository.UpdateStoreHierarchy(customHierarchymodel));
}
