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);
}
}
