public ActionResult SaveSocialInsuranceDetail(SocialInsuranceDetail obj) { var db = new SocialInsuranceDetailDAL(); int staffID = 0; int.TryParse(Session["StaffID"].ToString(), out staffID); var result = db.SaveSocialInsuranceDetail(Global.CurrentUser.RoleId, 1, obj, obj.StaffID); if (result.IsSuccess == true && obj.InsuranceID == 0) { result.Message = AppRes.MSG_INSERT_SUCCESSFUL; } else if (result.IsSuccess == true && obj.InsuranceID != 0) { result.Message = AppRes.MS_Update_success; } else if (result.IsSuccess == false && result.existedResult == -1) { result.Message = AppRes.FromMonthValidate + result.ExistedDate; } return(Content(JsonConvert.SerializeObject(new { result }))); }
public SystemMessage SaveSocialInsuranceDetail(int roleId, int idTable, SocialInsuranceDetail obj, int staffID) { SystemMessage systemMessage = new SystemMessage(); try { var param1 = new DynamicParameters(); param1.Add("@FromMonth", obj.FromMonth); param1.Add("@StaffID", staffID); param1.Add("@AutoID", obj.AutoID); param1.Add("@ExistedResult", 0, DbType.Int32, ParameterDirection.InputOutput); param1.Add("@ExistedDate", "", DbType.String, ParameterDirection.InputOutput); UnitOfWork.ProcedureExecute("SocialInsuranceDetail_CheckFromMonth", param1); var existedResult = param1.GetDataOutput <int>("@ExistedResult"); var existedDate = param1.GetDataOutput <string>("@ExistedDate"); if (existedResult < 0) { systemMessage.IsSuccess = false; systemMessage.existedResult = existedResult; if (existedDate != "") { DateTime tempDate = Convert.ToDateTime(existedDate, CultureInfo.InvariantCulture); systemMessage.ExistedDate = tempDate.ToString().Substring(3, 8); } return(systemMessage); } else { var param = new DynamicParameters(); param.Add("@StaffID", staffID); param.Add("@InsuranceCode", obj.InsuranceCode); param.Add("@InsuranceNumber", obj.InsuranceNumber); param.Add("@HealthNumber", obj.HealthNumber); param.Add("@FamilyCode", obj.FamilyCode); param.Add("@MonthStart", obj.MonthStart); param.Add("@PlaceHold", obj.PlaceHold); param.Add("@InsuranceID", obj.InsuranceID); param.Add("@FromMonth", obj.FromMonth); param.Add("@ToMonth", obj.ToMonth); param.Add("@Status", obj.Status); param.Add("@BasicSalary", obj.BasicSalary); param.Add("@RateCompany", obj.RateCompany); param.Add("@RatePerson", obj.RatePerson); param.Add("@DateReturn", obj.DateReturn); param.Add("@PlaceHealthCare", obj.PlaceHealthCare); param.Add("@Regime", obj.Regime); param.Add("@ApproveStatus", obj.ApproveStatus); param.Add("@Note", obj.Note); param.Add("@InsuranceID", obj.InsuranceID, DbType.Int32, ParameterDirection.InputOutput); param.Add("@AutoID", obj.AutoID, DbType.Int32, ParameterDirection.InputOutput); UnitOfWork.ProcedureExecute("SocialInsuranceDetail_Save", param); systemMessage.IsSuccess = true; return(systemMessage); } } catch (Exception e) { systemMessage.IsSuccess = false; systemMessage.Message = e.ToString(); return(systemMessage); } }