public DataSet GetAllDeathReaons()
        {
            DataSet ds = CspfDatabaseHelper.SelectInDataSetFromStoredProcedure(
                AccessHelper.ConnectionString, 6000, "Death_Reason_Select", "Table");

            return(ds);
        }
Пример #2
0
        public DataSet GetAllDisableTypes()
        {
            DataSet ds = CspfDatabaseHelper.SelectInDataSetFromStoredProcedure(
                AccessHelper.ConnectionString, 6000, "Disable_Types_Select", "Table");

            return(ds);
        }
Пример #3
0
        public DataSet CheckDepositValues(DataTable dt)
        {
            DataSet ds = CspfDatabaseHelper.SelectInDataSetFromStoredProcedure(
                AccessHelper.ConnectionString, 6000, "SP_CheckDepositValues", "Table",
                CspfDatabaseHelper.GetSqlParameter_Table("@DepositValuesTable", dt, "FishValueTable"));

            return(ds);
        }
Пример #4
0
        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);
        }
Пример #7
0
        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);
        }
Пример #9
0
        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);
        }
Пример #12
0
        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"]));
            }
        }