public IHttpActionResult UpdateLookUpValue(MasterDepartment data)
{
if (data != null)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var record = entity.Departments.Where(x => x.DeptCode == data.DeptCode).First();
record.DeptDesc = data.DeptDesc;
record.Comm = data.Comm;
record.DiscPerc = data.DiscPerc;
record.Threshold = data.Threshold;
try
{
entity.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
throw;
}
}
return(Ok(data));
}
public IHttpActionResult Post([FromBody] MasterDepartment masterDepartment)
{
var userCtx = base.GetUserContext();
_masterDepartmentService.Save(masterDepartment, userCtx);
return(Ok());
}
private bool CreateDm(string code, string name, string remark, bool status)
{
bool res = false;
MasterDepartment department_Master = new MasterDepartment();
try
{
department_Master.Code = code;
department_Master.Name = name;
department_Master.Remark = remark;
//department_Master.Id = ;
department_Master.CompanyId = 123;
department_Master.IsUsed = true;
department_Master.Status = status;
department_Master.CreatedBy = _configuration.GetValue <string>("HardcodeValue:Createdby");
department_Master.CreatedDatetime = DateTime.UtcNow;
_context.Add(department_Master);
_context.SaveChanges();
res = true;
}
catch (Exception ex)
{
res = false;
}
return(res);
}
private bool UpdateDm(string code, string name, string remark, bool status)
{
bool res = false;
try
{
MasterDepartment department_Master = _context.MasterDepartment.FirstOrDefault(m => m.Code.Equals(code));
if (department_Master != null)
{
department_Master.Name = name;
department_Master.Remark = remark;
department_Master.Status = status;
department_Master.ModifiedDatetime = DateTime.UtcNow;
department_Master.ModifiedBy = _configuration.GetValue <string>("HardcodeValue:Modifiedby");
_context.SaveChanges();
res = true;
}
}
catch (Exception ex)
{
res = false;
}
return(res);
}
public void Save(MasterDepartment masterDepartment, UserContext userCtx)
{
if (masterDepartment.Id == 0)
{
_masterDepartmentRepository.SaveMasterDepartment(masterDepartment, userCtx);
}
else
{
_masterDepartmentRepository.UpdateMasterDepartment(masterDepartment, userCtx);
}
}
public async Task <IActionResult> Edit(int id, [FromForm] MasterDepartment department_Master)
{
if (ModelState.IsValid)
{
try
{
bool isCodeExist = _context.MasterDepartment.Any(m => m.Code.Equals(department_Master.Code) && !m.Id.Equals(id));
if (isCodeExist)
{
ModelState.AddModelError("Code", "Code Already Exists!");
return(View(department_Master));
//return RedirectToAction(nameof(Index), new { error = "Code exists" });
}
MasterDepartment db_department_master = _context.MasterDepartment.FirstOrDefault(m => m.Id.Equals(department_Master.Id));
if (db_department_master == null || id != department_Master.Id)
{
return(NotFound());
}
OldData oldData = new OldData();
oldData.Code = db_department_master.Code;
oldData.Name = db_department_master.Name;
oldData.Remark = db_department_master.Remark;
oldData.Status = db_department_master.Status;
string oldJson = JsonConvert.SerializeObject(oldData);
string newJson = JsonConvert.SerializeObject(department_Master);
db_department_master.Code = department_Master.Code;
db_department_master.Name = department_Master.Name;
db_department_master.Remark = department_Master.Remark;
db_department_master.Status = department_Master.Status;
db_department_master.ModifiedBy = _configuration.GetValue <string>("HardcodeValue:Createdby");
db_department_master.ModifiedDatetime = DateTime.UtcNow;
_context.Update(db_department_master);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!Department_MasterExists(department_Master.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(department_Master));
}
public async Task AddAsync(DepartmentModel model)
{
var department = new MasterDepartment
{
DepartmentId = model.DepartmentId,
DepartmentName = model.DepartmentName,
DepartmentCode = model.DepartmentCode,
DepartmentGroup = model.DepartmentGroup
};
await _departmentRepository.AddAsync(department);
}
public IHttpActionResult DeleteLookUpValue(MasterDepartment data)
{
var record = entity.Departments.Where(x => x.DeptCode == data.DeptCode).First();
if (record == null)
{
return(NotFound());
}
entity.Departments.Remove(record);
entity.SaveChanges();
return(Ok(record));
}
public void InsertMasterDepartment(MasterDepartment masterDepartment)
{
var sqlParam = new MySqlSpParam();
sqlParam.StoreProcedureName = AppConstants.StoreProcedure.spMasterDepartment_Insert;
sqlParam.StoreProcedureParam = new MySqlParameter[] {
new MySqlParameter("@departmentName", masterDepartment.DepartmentName),
new MySqlParameter("@departmentHead", masterDepartment.DepartmentHead),
new MySqlParameter("@isValid", masterDepartment.IsValid),
new MySqlParameter("@createdBy", masterDepartment.CreatedBy),
new MySqlParameter("@createdOn", masterDepartment.CreatedOn)
};
DataAccessHelper.ExecuteNonQuery(sqlParam.ToSqlCommand(),
sqlParam.StoreProcedureParam);
}
public async Task <bool> DeleteDepartmentById(int typeId)
{
try
{
MasterDepartment department = await this.therapistContext.MasterDepartment.Where(x => x.DepartmentId == typeId).FirstOrDefaultAsync();
department.IsDeleted = true;
await this.therapistContext.SaveChangesAsync();
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <bool> ChangeDepartmentStatus(DepartmentsList department)
{
try
{
MasterDepartment masterDepartment = await this.therapistContext.MasterDepartment.Where(x => x.DepartmentId == department.DepartmentId).FirstOrDefaultAsync();
masterDepartment.IsActive = department.IsActive;
await this.therapistContext.SaveChangesAsync();
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <DepartmentData> GetDepartmentById(int departmentId)
{
try
{
DepartmentData department = new DepartmentData();
MasterDepartment masterDepartment = await this.therapistContext.MasterDepartment.Where(x => x.DepartmentId == departmentId).FirstOrDefaultAsync();
department.DepartmentId = Int32.Parse(masterDepartment.DepartmentId.ToString());
department.DepartmentName = masterDepartment.DepartmentName;
department.DepartmentCode = masterDepartment.DepartmentCode;
return(department);
}
catch (Exception ex)
{
throw ex;
}
}
public IHttpActionResult SaveLookUpValue(MasterDepartment data)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
entity.Departments.Add(new Department
{
DeptCode = data.DeptCode,
DeptDesc = data.DeptDesc,
Comm = data.Comm,
DiscPerc = data.DiscPerc,
Threshold = data.Threshold
});
entity.SaveChanges();
return(Ok(data));
}
public void AddDepartment(AddDepartmentViewModel model)
{
try
{
if (model != null)
{
MasterDepartment entity = new MasterDepartment();
entity.DepartmentName = model.DepartmentName;
db.MasterDepartments.Add(entity);
}
else
{
throw new Exception("Department could not be blank!");
}
}
catch (Exception)
{
throw;
}
}
public void TestInitialize()
{
_department = new MasterDepartment()
{
DepartmentId = 1,
DepartmentName = "A",
DepartmentCode = "B",
DepartmentGroup = "C"
};
_departments = new List <MasterDepartment>
{
_department
};
_mockAsyncRepository = new Mock <IAsyncRepository <MasterDepartment> >();
_mockAsyncRepository.Setup(x => x.GetAllAsync()).ReturnsAsync(_departments);
_mockAsyncRepository.Setup(x => x.GetByIdAsync(It.IsAny <int>())).ReturnsAsync(_department);
_departmentService = new DepartmentService(_mockAsyncRepository.Object);
}
public async Task <IActionResult> Create([FromForm] MasterDepartment department_Master)
{
if (ModelState.IsValid)
{
bool isCodeExist = _context.MasterDepartment.Any(m => m.Code.Equals(department_Master.Code));
if (isCodeExist)
{
ModelState.AddModelError("Code", "Code Already Exists!");
return(View(department_Master));
}
string newJson = JsonConvert.SerializeObject(department_Master);
department_Master.CompanyId = 123;
department_Master.IsUsed = true;
department_Master.CreatedBy = _configuration.GetValue <string>("HardcodeValue:Createdby");
department_Master.CreatedDatetime = DateTime.UtcNow;
_context.Add(department_Master);
AuditService.InsertActionLog(department_Master.CompanyId, department_Master.CreatedBy, "Create", "Master Department", null, newJson);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(department_Master));
}
public IActionResult EditA([FromForm] MasterDepartment department_Master)
{
return(View(department_Master));
}
public void UpdateMasterDepartment(MasterDepartment masterDepartment, UserContext userCtx)
{
masterDepartment.UpdatedBy = userCtx.UserId;
masterDepartment.UpdatedOn = DateTime.Now.ToMySqlDateString();
_masterDepartmentDataAccess.UpdateMasterDepartment(masterDepartment);
}
public async Task <FileResult> Export()
{
string[] names = typeof(MasterDepartment).GetProperties().Select(property => property.Name).ToArray();
string[] columnNames = new string[] { "Code", "Name", "Remark", "Status" };
MasterDepartment entities = new MasterDepartment();
var customers = await _context.MasterDepartment.ToListAsync();
//Build the CSV file data as a Comma separated string.
string csv = string.Empty;
foreach (string columnName in columnNames)
{
//Add the Header row for CSV file.
csv += columnName + ',';
}
//remove symbol "," behind
csv = csv.Remove(csv.Length - 1, 1);
//Add new line.
csv += "\r\n";
foreach (var customer in customers)
{
//Add the Data rows.
csv += customer.Code.Replace(",", ";") + ',';
csv += customer.Name.Replace(",", ";") + ',';
if (customer.Remark != null)
{
csv += customer.Remark.Replace(",", ";") + ',';
}
else
{
customer.Remark = "";
csv += customer.Remark.Replace(",", ";") + ',';
}
if (customer.Status != false)
{
string Status = "YES";
csv += Status.Replace(",", ";");
}
if (customer.Status != true)
{
string Status = "NO";
csv += Status.Replace(",", ";");
}
//Add new line.
csv += "\r\n";
}
var file = "DepartmentMaster.csv";
//Download the CSV file.
byte[] bytes = Encoding.ASCII.GetBytes(csv);
return(File(bytes, "application/text", file));
}
