/// <summary>
/// Create Department
/// </summary>
/// <returns></returns>
public int CreateDepartment(CreateStoreDepartmentModel createDepartmentModel)
{
int result = 0;
try
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("SP_CreateDepartment", conn);
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@Brand_ID", string.IsNullOrEmpty(createDepartmentModel.BrandID)? "" : createDepartmentModel.BrandID.TrimEnd(','));
cmd.Parameters.AddWithValue("@_StoreID", string.IsNullOrEmpty(createDepartmentModel.StoreID) ? "" : createDepartmentModel.StoreID.TrimEnd(','));
cmd.Parameters.AddWithValue("@_DepartmentID", createDepartmentModel.DepartmentID);
cmd.Parameters.AddWithValue("@_FunctionID", createDepartmentModel.FunctionID);
cmd.Parameters.AddWithValue("@_Status", Convert.ToInt16(createDepartmentModel.Status));
cmd.Parameters.AddWithValue("@_TenantID", createDepartmentModel.TenantID);
cmd.Parameters.AddWithValue("@_UserID", createDepartmentModel.CreatedBy);
cmd.CommandType = CommandType.StoredProcedure;
result = Convert.ToInt32(cmd.ExecuteNonQuery());
}
catch (Exception)
{
throw;
}
finally
{
if (conn != null)
{
conn.Close();
}
}
return(result);
}
public ResponseModel UpdateBrandDepartmentMapping([FromBody] CreateStoreDepartmentModel updateDepartmentModel)
{
ResponseModel objResponseModel = new ResponseModel();
StoreDepartmentCaller newDept = new StoreDepartmentCaller();
int statusCode = 0;
string statusMessage = "";
int UpdateCount = 0;
try
{
string token = Convert.ToString(Request.Headers["X-Authorized-Token"]);
Authenticate authenticate = new Authenticate();
authenticate = SecurityService.GetAuthenticateDataFromToken(_radisCacheServerAddress, SecurityService.DecryptStringAES(token));
updateDepartmentModel.TenantID = authenticate.TenantId;
updateDepartmentModel.CreatedBy = authenticate.UserMasterID;
UpdateCount = newDept.UpdateDepartmentMapping(new StoreDepartmentService(_connectioSting), updateDepartmentModel);
statusCode =
UpdateCount == 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 = UpdateCount;
}
catch (Exception)
{
throw;
}
return(objResponseModel);
}
/// <summary>
/// Update Department Mapping
/// </summary>
/// <returns></returns>
public int UpdateDepartmentMapping(CreateStoreDepartmentModel updateDepartmentModel)
{
int result = 0;
try
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("SP_UpdateDepartmentMapping", conn);
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@_DepartmentBrandID", updateDepartmentModel.DepartmentBrandID);
cmd.Parameters.AddWithValue("@_BrandID", Convert.ToInt32(updateDepartmentModel.BrandID));
cmd.Parameters.AddWithValue("@_StoreID", Convert.ToInt32(updateDepartmentModel.StoreID));
cmd.Parameters.AddWithValue("@_DepartmentID", updateDepartmentModel.DepartmentID);
cmd.Parameters.AddWithValue("@_FunctionID", updateDepartmentModel.FunctionID);
cmd.Parameters.AddWithValue("@_Status", Convert.ToInt16(updateDepartmentModel.Status));
cmd.Parameters.AddWithValue("@_TenantID", updateDepartmentModel.TenantID);
cmd.Parameters.AddWithValue("@_CreatedBy", updateDepartmentModel.CreatedBy);
cmd.CommandType = CommandType.StoredProcedure;
result = Convert.ToInt32(cmd.ExecuteNonQuery());
}
catch (Exception)
{
throw;
}
finally
{
if (conn != null)
{
conn.Close();
}
}
return(result);
}
public ResponseModel CreateDepartment([FromBody] CreateStoreDepartmentModel createDepartmentModel)
{
StoreDepartmentCaller newCreatDept = new StoreDepartmentCaller();
ResponseModel objResponseModel = new ResponseModel();
int StatusCode = 0;
string statusMessage = "";
try
{
////Get token (Double encrypted) and get the tenant id
string token = Convert.ToString(Request.Headers["X-Authorized-Token"]);
Authenticate authenticate = new Authenticate();
authenticate = SecurityService.GetAuthenticateDataFromToken(_radisCacheServerAddress, SecurityService.DecryptStringAES(token));
createDepartmentModel.CreatedBy = authenticate.UserMasterID;
createDepartmentModel.TenantID = authenticate.TenantId;
int result = newCreatDept.CreateStoreDepartment(new StoreDepartmentService(_connectioSting), createDepartmentModel);
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 int CreateStoreDepartment(IStoreDepartment Store, CreateStoreDepartmentModel createDepartmentModel)
{
ImasterDepartment = Store;
return(ImasterDepartment.CreateDepartment(createDepartmentModel));
}
public int UpdateDepartmentMapping(IStoreDepartment dept, CreateStoreDepartmentModel updateDepartmentModel)
{
ImasterDepartment = dept;
return(ImasterDepartment.UpdateDepartmentMapping(updateDepartmentModel));
}
