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