public EmployeeGangDetail Add(EmployeeGangDetail EGD)
{
var sqlQuery = @"INSERT INTO EMPLOYEEGANGDETAIL (EMPLOYEEGANG, EMPLOYEE, COMPANYSITE, INPUTBY, INPUTDATE, UPDATEBY, UPDATEDATE) VALUES
(" + EGD.EMPLOYEEGANG + @", " + EGD.EMPLOYEE + ", '" + EGD.COMPANYSITE + @"', " + EGD.INPUTBY + ", '" + EGD.INPUTDATE + @"', " + EGD.UPDATEBY + ", '" + EGD.UPDATEDATE + @"'); " + "SELECT CAST(SCOPE_IDENTITY() as int)";
var SID = _db.Query <int>(sqlQuery, EGD).Single();
EGD.SID = SID;
return(EGD);
}
public EmployeeGangDetail Update(EmployeeGangDetail EGD)
{
var sqlQuery =
"UPDATE EMPLOYEEGANGDETAIL " +
"SET EMPLOYEEGANG = '" + EGD.EMPLOYEEGANG + "', " +
" EMPLOYEE = '" + EGD.EMPLOYEE + "', " +
" COMPANYSITE = '" + EGD.COMPANYSITE + "', " +
" UPDATEBY = '" + Convert.ToInt32(EGD.UPDATEBY) + "', " +
" UPDATEDATE = '" + EGD.UPDATEDATE + "' " +
"WHERE SID = " + EGD.SID + "";
this._db.Execute(sqlQuery, EGD);
return(EGD);
}
public JsonResult Edit(EmployeeGangDetail EmployeeGangDetail)
{
try
{
if (ModelState.IsValid)
{
EmployeeGangDetail.UPDATEBY = int.Parse(Session["userid"].ToString());
EmployeeGangDetail.UPDATEDATE = DateTime.Now;
EGD.Update(EmployeeGangDetail);
}
}
catch
{
return(Json("error"));
}
return(Json("success"));
}
public JsonResult Create(EmployeeGangDetail EmployeeGangDetail)
{
try
{
if (ModelState.IsValid)
{
EmployeeGangDetail.INPUTBY = int.Parse(Session["userid"].ToString());
EmployeeGangDetail.INPUTDATE = DateTime.Now;
EmployeeGangDetail.UPDATEBY = int.Parse(Session["userid"].ToString());
EmployeeGangDetail.UPDATEDATE = DateTime.Now;
EGD.Add(EmployeeGangDetail);
}
}
catch (Exception ex)
{
return(Json("error"));
}
return(Json("success"));
}
