public DataSet GetAllDeathReaons()
{
DataSet ds = CspfDatabaseHelper.SelectInDataSetFromStoredProcedure(
AccessHelper.ConnectionString, 6000, "Death_Reason_Select", "Table");
return(ds);
}
public DataSet GetAllDisableTypes()
{
DataSet ds = CspfDatabaseHelper.SelectInDataSetFromStoredProcedure(
AccessHelper.ConnectionString, 6000, "Disable_Types_Select", "Table");
return(ds);
}
public DataSet CheckDepositValues(DataTable dt)
{
DataSet ds = CspfDatabaseHelper.SelectInDataSetFromStoredProcedure(
AccessHelper.ConnectionString, 6000, "SP_CheckDepositValues", "Table",
CspfDatabaseHelper.GetSqlParameter_Table("@DepositValuesTable", dt, "FishValueTable"));
return(ds);
}
public DataSet GetOrganInsuredData(int organinsuredcode)
{
DataSet ds = CspfDatabaseHelper.SelectInDataSetFromStoredProcedure(
AccessHelper.ConnectionString, 6000, "SP_GetDastgahInfo", "Table",
CspfDatabaseHelper.GetSqlParameter_Int("@DastgahCode", organinsuredcode));
return(ds);
}
public DataSet GetContractInit(int organinsuredcode)
{
DataSet ds = CspfDatabaseHelper.SelectInDataSetFromStoredProcedure(
AccessHelper.ConnectionString, 6000, "Contract_Init_Get", "Table",
CspfDatabaseHelper.GetSqlParameter_Int("@UnitCode", organinsuredcode));
return(ds);
}
public DataSet GetClaimRecords(int organinsuredcode, int year)
{
DataSet ds = CspfDatabaseHelper.SelectInDataSetFromStoredProcedure(
AccessHelper.ConnectionString, 6000, "SP_GetGharamatList_ForUnit", "Table",
CspfDatabaseHelper.GetSqlParameter_Int("@UnitCode", organinsuredcode),
CspfDatabaseHelper.GetSqlParameter_Int("@Year", year));
return(ds);
}
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 GetOrganEmail(int organinsuredcode)
{
string result = "";
DataSet ds = CspfDatabaseHelper.SelectInDataSetFromStoredProcedure(
AccessHelper.ConnectionString, 6000, "SP_GetOrganEmailInfo", "Table",
CspfDatabaseHelper.GetSqlParameter_Int("@DastgahCode", organinsuredcode));
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 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);
}
public void Refresh(int dastgahPardakhtCode, int shahrPardakhtCode)
{
DastgahPardakhtCode = dastgahPardakhtCode;
DastgahPardakhtName = "";
ShahrPardakhtCode = shahrPardakhtCode;
ShahrPardakhtName = "";
Mobile = 0;
NumTaaholOlad = 0;
NumSayer = 0;
IsClosed = true;
TaaholOladDetailIsReceived = false;
NazarsanjiDone = false;
DataSet ds = CspfDatabaseHelper.SelectInDataSetFromStoredProcedure(
SessionHelper.ConnectionString, 6000, "SGetZihesabInfo", "Table",
CspfDatabaseHelper.GetSqlParameter_Int("DastgahPardakhtCode", dastgahPardakhtCode),
CspfDatabaseHelper.GetSqlParameter_Int("ShahrPardakhtCode", shahrPardakhtCode)
);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
MahJariOid = Convert.ToInt64((ds.Tables[0].Rows[0]["OidVaziatZihesab"]));
DastgahPardakhtName = Convert.ToString((ds.Tables[0].Rows[0]["DastgahPardakhtName"]));
ShahrPardakhtName = Convert.ToString((ds.Tables[0].Rows[0]["ShahrPardakhtName"]));
Mobile = Convert.ToInt64((ds.Tables[0].Rows[0]["Mobile"]));
NumTaaholOlad = Convert.ToInt32((ds.Tables[0].Rows[0]["NumTaaholOlad"]));
NumSayer = Convert.ToInt32((ds.Tables[0].Rows[0]["NumSayer"]));
IsClosed = Convert.ToBoolean((ds.Tables[0].Rows[0]["IsClosed"]));
Ostan = Convert.ToInt32((ds.Tables[0].Rows[0]["Ostan"]));
OstanWebAddress = Convert.ToString((ds.Tables[0].Rows[0]["OstanWebAddress"]));
TaaholOladDetailIsReceived = Convert.ToBoolean((ds.Tables[0].Rows[0]["TaaholOladDetailIsReceived"]));
TedadBazneshastZende = Convert.ToInt32((ds.Tables[0].Rows[0]["TedadBazneshastZende"]));
NazarsanjiDone = Convert.ToBoolean((ds.Tables[0].Rows[0]["NazarsanjiDone"]));
Name = Convert.ToString((ds.Tables[0].Rows[0]["Name"]));
Famil = Convert.ToString((ds.Tables[0].Rows[0]["Famil"]));
}
}