public ResponseData AddByEntity(DepartmentViewModel data)
{
using (SATEntities db = new SATEntities())
{
ResponseData result = new Models.ResponseData();
try
{
tb_Department model = new tb_Department();
model.DepID = data.DepID;
model.DepName = data.DepName;
model.DepStatus = (data.Status == "1") ? true : false;
model.DivID = (int)data.DivID;
model.CreateBy = UtilityService.User.UserID;
model.CreateDate = DateTime.Now;
model.ModifyBy = UtilityService.User.UserID;
model.ModifyDate = DateTime.Now;
db.tb_Department.Add(model);
db.SaveChanges();
}
catch (Exception)
{
}
return(result);
}
}
public JsonResult CreateUserDepart()
{
tb_Department depart = new tb_Department();
depart.Name = "depart1";
depart.Description = "1";
tb_User user = new tb_User();
user.UserName = "******";
user.Address = "1";
var result = service.InsertUserDepart(user, depart);
return(Json(result, JsonRequestBehavior.AllowGet));
}
public tb_Department GetDepartAssembleByDepartId(int id)
{
try
{
tb_Department department = base.Find <tb_Department>(id);
List <tb_User> userList = base.Query <tb_User>(_ => _.DepartmentId == id).ToList();
department.tb_Users = userList;
return(department);
}
catch (Exception ex)
{
this.GetType().Fatal(System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
return(null);
}
}
public bool InsertUserDepart(tb_User user, tb_Department department)
{
using (var tran = CreateScopeTransaction())
{
try
{
var newId = base.Insert(department);
var temp = base.Get <tb_Department>(newId.Value);
temp = base.DBManager.Connection.Get <tb_Department>(newId.Value);
user.DepartmentId = newId.Value;
newId = base.Insert(user);
if (tran != null)
{
tran.Complete();
}
return(true);
}
catch (Exception ex)
{
this.GetType().Error(System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
return(false);
}
}
}
public JsonResult GetDepartAssembleByDepartId(int id)
{
tb_Department result = module.GetDepartAssembleByDepartId(id);
return(Json(result, JsonRequestBehavior.AllowGet));
}
private void AddUnit()
{
int C = 0;
if (Check_Save())
{
return;
}
try
{
dgvData.EndEdit();
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
foreach (var g in dgvData.Rows)
{
if (g.IsVisible.Equals(false))
{
var dd = (from ix in db.tb_Departments
where ix.id == Convert.ToInt16(g.Cells["id"].Value)
select ix).ToList();
if (dd.Count > 0)
{
dbClss.AddHistory(this.Name, "ลบ", "ลบแผนก [" + dd.FirstOrDefault().Department + "]", "");
db.tb_Departments.DeleteAllOnSubmit(dd);
db.SubmitChanges();
C += 1;
}
}
}
foreach (var g in dgvData.Rows)
{
if (g.IsVisible)
{
if (Convert.ToBoolean(g.Cells["dgvC"].Value))
{
if (Convert.ToInt16(g.Cells["id"].Value) <= 0)
{
var a = (from ix in db.tb_Departments
where ix.Department.ToUpper() == Convert.ToString(g.Cells["Department"].Value).Trim().ToUpper()
select ix).ToList();
if (a.Count() <= 0)
{
tb_Department gy = new tb_Department();
gy.Department = Convert.ToString(g.Cells["Department"].Value).Trim();
gy.CreateDate = DateTime.Now;
gy.CreateBy = ClassLib.Classlib.User;
gy.Status = Convert.ToBoolean(g.Cells["Status"].Value);
db.tb_Departments.InsertOnSubmit(gy);
db.SubmitChanges();
dbClss.AddHistory(this.Name, "เพิ่มแผนก", "เพิ่มแผนก [" + gy.Department + " Status : " + gy.Status.ToString() + "]", "");
C += 1;
}
}
else
{
var a = (from ix in db.tb_Departments
where ix.id == Convert.ToInt16(g.Cells["id"].Value)
select ix).ToList();
if (a.Count > 0)
{
var unit1 = (from ix in db.tb_Departments
where ix.id == Convert.ToInt16(g.Cells["id"].Value)
select ix).First();
unit1.Department = Convert.ToString(g.Cells["Department"].Value).Trim();
unit1.Status = Convert.ToBoolean(g.Cells["Status"].Value);
unit1.CreateDate = DateTime.Now;
unit1.CreateBy = ClassLib.Classlib.User;
C += 1;
db.SubmitChanges();
dbClss.AddHistory(this.Name, "แก้ไข", "แก้ไขแผนก [" + unit1.Department + " Status : " + unit1.Status.ToString() + "]", "");
}
}
}
}
//else //Delete
//{
// var dd = (from ix in db.tb_Departments
// where ix.id == Convert.ToInt16(g.Cells["id"].Value)
// select ix).ToList();
// if (dd.Count > 0)
// {
// dbClss.AddHistory(this.Name, "ลบ", "ลบแผนก [" + dd.FirstOrDefault().Department + "]", "");
// db.tb_Departments.DeleteAllOnSubmit(dd);
// db.SubmitChanges();
// }
//}
}
}
}
catch (Exception ex) { MessageBox.Show(ex.Message);
dbClss.AddError(this.Name, ex.Message, this.Name); }
if (C > 0)
{
MessageBox.Show("บันทึกสำเร็จ!");
DataLoad();
ViewClick();
}
}
