public ActionResult SaveAtens(AttendenceVM Atens) { List <SessionListnew> list = Session["SesDet"] as List <SessionListnew>; if (list == null) { return(Redirect("Login/InLogin")); } else { Atens.UserName = list[0].user_name; Atens.CmpyCode = list[0].CmpyCode; return(Json(_AtenService.SaveAtens(Atens), JsonRequestBehavior.AllowGet)); } }
public AttendenceVM SaveAtens(AttendenceVM Atens) { try { if (!Atens.EditFlag) { int Atens1 = _EzBusinessHelper.ExecuteScalar("Select count(*) from MLH033 where CmpyCode=' " + Atens.CmpyCode + "' and Code='" + Atens.Code + "'"); if (Atens1 == 0) { Atens.SaveFlag = _EzBusinessHelper.ExecuteNonQuery1("insert into MLH033(CmpyCode,Code,LeaveName,CountryCode) values('" + Atens.CmpyCode + "','" + Atens.Code + "','" + Atens.LeaveName + "','" + Atens.CountryCode + "')"); _EzBusinessHelper.ActivityLog(Atens.CmpyCode, Atens.UserName, "Add Leave Type Master", Atens.Code, Environment.MachineName); //Atens.SaveFlag = true; Atens.ErrorMessage = string.Empty; } else { Atens.SaveFlag = false; Atens.ErrorMessage = "Duplicate Record"; } return(Atens); } var AtensEdit = _EzBusinessHelper.ExecuteScalar("Select count(*) from MLH033 where CmpyCode='" + Atens.CmpyCode + "' and Code='" + Atens.Code + "'"); if (AtensEdit != 0) { Atens.SaveFlag = _EzBusinessHelper.ExecuteNonQuery1("update MLH033 set LeaveName='" + Atens.LeaveName + "',CountryCode='" + Atens.CountryCode + "' where CmpyCode='" + Atens.CmpyCode + "' and Code='" + Atens.Code + "'"); _EzBusinessHelper.ActivityLog(Atens.CmpyCode, Atens.UserName, "Update Leave Type Master", Atens.Code, Environment.MachineName); Atens.ErrorMessage = string.Empty; } else { Atens.SaveFlag = false; Atens.ErrorMessage = "Record not available"; } } catch { Atens.SaveFlag = false; // unit.ErrorMessage = exceptionMessage; } return(Atens); }
public AttendenceForm( ) { InitializeComponent(); aVM = new AttendenceVM(); }
public AttendenceVM SaveAtens(AttendenceVM Atens) { return(_AtenRepo.SaveAtens(Atens)); }