public DataSet GetInsuredData(long nationalcode, int unitcode)
{
DataSet ds = CspfDatabaseHelper.SelectInDataSetFromStoredProcedure(
AccessHelper.ConnectionString, 6000, "SP_GetBimehInfo", "Table",
CspfDatabaseHelper.GetSqlParameter_BigInt("@Nationalcode", nationalcode),
CspfDatabaseHelper.GetSqlParameter_Int("@UnitCode", unitcode)
);
return(ds);
}
public DataSet GetBaseBenefit(CLaimBenefitModel model)
{
DataSet ds = CspfDatabaseHelper.SelectInDataSetFromStoredProcedure(
AccessHelper.ConnectionString, 6000, "SP_GetMablagh_Original", "Table",
CspfDatabaseHelper.GetSqlParameter_BigInt("@Nationalcode", model.NationalCode),
CspfDatabaseHelper.GetSqlParameter_Int("@UnitCode", model.Unitcode),
CspfDatabaseHelper.GetSqlParameter_Int("@Year", model.Year),
CspfDatabaseHelper.GetSqlParameter_VarChar("@DEATH_DATE", model.Death_Date));
return(ds);
}
public string SubmitClaim(ClaimModel model)
{
string result = "";
DataSet ds = CspfDatabaseHelper.SelectInDataSetFromStoredProcedure(
AccessHelper.ConnectionString, "SP_SAVE_Gharamat",
CspfDatabaseHelper.GetSqlParameter_BigInt("@Nationalcode", model.NationalCode),
CspfDatabaseHelper.GetSqlParameter_Int("@Unit_Code", model.UnitCode),
CspfDatabaseHelper.GetSqlParameter_VarChar("@AccsidentDate", model.AccsidentDate),
CspfDatabaseHelper.GetSqlParameter_Int("@Death_Reason_Id", model.Death_Reason_Id),
CspfDatabaseHelper.GetSqlParameter_VarChar("@elatefot", model.Elatefot),
CspfDatabaseHelper.GetSqlParameter_VarChar("@elatenaqseozv", model.Elatenaqseozv),
CspfDatabaseHelper.GetSqlParameter_Int("@Disable_Reason_Id", model.Disable_Reason_Id),
CspfDatabaseHelper.GetSqlParameter_Int("@naqsozvitems", model.NaqsozvItems),
CspfDatabaseHelper.GetSqlParameter_Int("@GharamatValue", model.GharamatValue),
CspfDatabaseHelper.GetSqlParameter_Int("@OriginalGharamatValue", model.OriginalGharamatValue),
CspfDatabaseHelper.GetSqlParameter_VarChar("@AccountNo", model.AccountNo),
CspfDatabaseHelper.GetSqlParameter_VarChar("@BankName", model.BankName),
CspfDatabaseHelper.GetSqlParameter_Int("@BankCode", model.BankCode),
CspfDatabaseHelper.GetSqlParameter_VarChar("@RegDate", model.RegDate),
CspfDatabaseHelper.GetSqlParameter_Int("@RegUserId", model.RegUserId),
CspfDatabaseHelper.GetSqlParameter_Int("@FormId", model.FormId),
new SqlParameter("@KartemeliImage", SqlDbType.VarBinary, 1000000)
{
Value = model.KartemeliImage
},
new SqlParameter("@GavahifotImage", SqlDbType.VarBinary, 1000000)
{
Value = model.GavahifotImage
},
CspfDatabaseHelper.GetSqlParameter_TinyInt("@GharamatType", model.GharamatType),
CspfDatabaseHelper.GetSqlParameter_Table("@DisableTable", model.DisableTable, "GharamatDisableType"),
CspfDatabaseHelper.GetSqlParameter_VarChar("@Mobiles", model.Mobiles));
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
result = ds.Tables[0].Rows[0][0].ToString();
}
return(result);
}
public string SubmitContract(ContractModel model)
{
string result = "";
DataSet ds = CspfDatabaseHelper.SelectInDataSetFromStoredProcedure(
AccessHelper.ConnectionString, "Sp_Save_Contract",
CspfDatabaseHelper.GetSqlParameter_Int("@status", model.Status),
CspfDatabaseHelper.GetSqlParameter_Int("@unitcode", model.Organinsuredcode),
CspfDatabaseHelper.GetSqlParameter_VarChar("@contractdate", model.ContractDate),
CspfDatabaseHelper.GetSqlParameter_Int("@worker_num", model.Worker_num),
CspfDatabaseHelper.GetSqlParameter_Int("@worker_start", model.Worker_start),
CspfDatabaseHelper.GetSqlParameter_Int("@worker_time", model.Worker_time),
CspfDatabaseHelper.GetSqlParameter_BigInt("@worker_pay", model.Worker_pay),
CspfDatabaseHelper.GetSqlParameter_Int("@ourbaz_start", model.Ourbaz_start),
CspfDatabaseHelper.GetSqlParameter_Int("@ourbaz_time", model.Ourbaz_time),
CspfDatabaseHelper.GetSqlParameter_Int("@ourbaz_num", model.Ourbaz_num),
CspfDatabaseHelper.GetSqlParameter_BigInt("@ourbaz_pay", model.Ourbaz_pay),
CspfDatabaseHelper.GetSqlParameter_Int("@otherbaz_num", model.Otherbaz_num),
CspfDatabaseHelper.GetSqlParameter_Int("@otherbaz_start", model.Otherbaz_start),
CspfDatabaseHelper.GetSqlParameter_Int("@otherbaz_time", model.Otherbaz_time),
CspfDatabaseHelper.GetSqlParameter_BigInt("@otherbaz_pay", model.Otherbaz_pay),
CspfDatabaseHelper.GetSqlParameter_Int("@timeoff_num", model.Timeoff_start),
CspfDatabaseHelper.GetSqlParameter_Int("@timeoff_start", model.Timeoff_start),
CspfDatabaseHelper.GetSqlParameter_Int("@timeoff_time", model.Timeoff_time),
CspfDatabaseHelper.GetSqlParameter_BigInt("@timeoff_pay", model.Timeoff_pay),
CspfDatabaseHelper.GetSqlParameter_BigInt("@contract_prize", model.Contract_prize),
CspfDatabaseHelper.GetSqlParameter_BigInt("@Deposit_sum", model.Deposit_sum),
CspfDatabaseHelper.GetSqlParameter_Int("@cym", model.ContractYearMonth),
CspfDatabaseHelper.GetSqlParameter_Int("@wo_old", model.Wo_old),
CspfDatabaseHelper.GetSqlParameter_Int("@ou_old", model.Ou_old),
CspfDatabaseHelper.GetSqlParameter_Int("@ot_old", model.Ot_old)
);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
result = ds.Tables[0].Rows[0][0].ToString();
}
return(result);
}