Ejemplo n.º 1
0
        /// <summary>
        /// Method to Get List of HostelStructure
        /// </summary>
        /// <param name="argEn">HostelStructure Entity is an Input.</param>
        /// <returns>Returns List of HostelStructure</returns>
        public List <HostelStructEn> GetList(HostelStructEn argEn)
        {
            List <HostelStructEn> loEnList = new List <HostelStructEn>();
            string sqlCmd = "select * from SAS_HostelStruct";

            try
            {
                if (!FormHelp.IsBlank(sqlCmd))
                {
                    using (IDataReader loReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType,
                                                                                 DataBaseConnectionString, sqlCmd).CreateDataReader())
                    {
                        while (loReader.Read())
                        {
                            HostelStructEn loItem = LoadObject(loReader);
                            loEnList.Add(loItem);
                        }
                        loReader.Close();
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(loEnList);
        }
Ejemplo n.º 2
0
        /// <summary>
        /// Method to Get List of Active or Inactive FeeTypes
        /// </summary>
        /// <param name="argEn">FeeTypes Entity is an Input.FeeTypeCode,FeeType,Hostel,Description,GLCode,Priority and Status are Input Properties.</param>
        /// <returns>Returns List of FeeTypes</returns>
        public List <HostelStructEn> GetHostelStudent(HostelStructEn argEn)
        {
            List <HostelStructEn> loEnList = new List <HostelStructEn>();


            string sqlCmd = "select * from SAS_HostelStruct hs inner join sas_student std on std.sako_code = hs.sahb_code and std.sabk_code = sahb_block where hs.sahs_code = '" + argEn.HostelStructureCode + "'";

            try
            {
                if (!FormHelp.IsBlank(sqlCmd))
                {
                    //FeeChargesDAL loDs = new FeeChargesDAL();
                    //FeeChargesEn loEn = new FeeChargesEn();
                    using (IDataReader loReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType,
                                                                                 DataBaseConnectionString, sqlCmd).CreateDataReader())
                    {
                        while (loReader.Read())
                        {
                            HostelStructEn loItem = new HostelStructEn();
                            loItem.Code = GetValue <string>(loReader, "sahb_code");
                            loEnList.Add(loItem);
                        }
                        loReader.Close();
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(loEnList);
        }
Ejemplo n.º 3
0
        /// <summary>
        /// Method to Get HostelStructucture Entity
        /// </summary>
        /// <param name="argEn">HostelStructucture Entity is an Input.HostelStuctureCode as Input Property.</param>
        /// <returns>Returns HostelStructucture Entity</returns>
        public HostelStructEn GetItem(HostelStructEn argEn)
        {
            HostelStructEn loItem = new HostelStructEn();
            string         sqlCmd = "Select * FROM SAS_HostelStruct WHERE SAHS_Code = @SAHS_Code";

            try
            {
                if (!FormHelp.IsBlank(sqlCmd))
                {
                    DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString);
                    _DatabaseFactory.AddInParameter(ref cmd, "@SAHS_Code", DbType.String, argEn.HostelStructureCode);
                    _DbParameterCollection = cmd.Parameters;

                    using (IDataReader loReader = _DatabaseFactory.GetIDataReader(Helper.GetDataBaseType, cmd,
                                                                                  DataBaseConnectionString, sqlCmd, _DbParameterCollection).CreateDataReader())
                    {
                        if (loReader != null)
                        {
                            loReader.Read();
                            loItem = LoadObject(loReader);
                        }
                        loReader.Close();
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(loItem);
        }
Ejemplo n.º 4
0
        //Created By : Jessica
        //Created Date :  19/02/16
        ///<summary>
        ///Method to Get List of Active or Inactive Hostels
        /// </summary>
        /// <param name="argEn">HostelStructure Entity is an Input. Code,Block and Status are Input Properties.</param>
        /// <returns>Returns List of HostelStructre</returns>
        public List <HostelStructEn> GetHostelStructList(HostelStructEn argEn)
        {
            List <HostelStructEn> loEnList = new List <HostelStructEn>();

            argEn.RoomTYpe = argEn.RoomTYpe.Replace("*", "%");
            argEn.Code     = argEn.Code.Replace("*", "%");
            argEn.Block    = argEn.Block.Replace("*", "%");

            string sqlCmd = "select * from SAS_HostelStruct WHERE SAHS_Code <> '0'";

            if (argEn.RoomTYpe.Length != 0)
            {
                sqlCmd = sqlCmd + " and SAHB_RoomTYpe like '" + argEn.RoomTYpe + "'";
            }
            if (argEn.Code.Length != 0)
            {
                sqlCmd = sqlCmd + " and SAHB_Code like '" + argEn.Code + "'";
            }
            if (argEn.Block.Length != 0)
            {
                sqlCmd = sqlCmd + " and SAHB_Block like '" + argEn.Block + "'";
            }
            //if (argEn.Status == true) sqlCmd = sqlCmd + " and SAFS_Status = 1";
            if (argEn.Status == true)
            {
                sqlCmd = sqlCmd + " and SAFS_Status = true";
            }
            //if (argEn.Status == false) sqlCmd = sqlCmd + " and SAFS_Status = 0 ";
            if (argEn.Status == false)
            {
                sqlCmd = sqlCmd + " and SAFS_Status = false ";
            }


            try
            {
                if (!FormHelp.IsBlank(sqlCmd))
                {
                    HostelStrDetailsDAL loHostelStrDet = new HostelStrDetailsDAL();

                    using (IDataReader loReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType,
                                                                                 DataBaseConnectionString, sqlCmd).CreateDataReader())
                    {
                        while (loReader.Read())
                        {
                            HostelStructEn loItem = LoadObject(loReader);
                            loItem.lstHFeeWithAmt = loHostelStrDet.GetHostelDetailsAmtList(loItem);
                            loEnList.Add(loItem);
                        }
                        loReader.Close();
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(loEnList);
        }
Ejemplo n.º 5
0
        //Created By : Jessica
        //Created Date :  19/02/16
        /// <summary>
        /// Method to Get List of Hostel Amounts
        /// </summary>
        /// <param name="argEn">HostelStruct Entity is an Input.HSCode as input Property</param>
        /// <returns>Returns List of HostelStruct</returns>
        public List <HostelStructEn> GetHostelDetailsAmtList(HostelStructEn argEn)
        {
            List <HostelStructEn> loEnList = new List <HostelStructEn>();
            string sqlCmd = @"
                            select  hsd.SAHS_Code , hsd.saft_code, hsd.sahd_priority,
                            hsd.safs_taxmode, ft.*,
                            local.saha_amount as Local_Amount, local.safa_gstamount as Local_GSTAmount, nonlocal.saha_amount as NonLocal_Amount, nonlocal.safa_gstamount as NonLocal_GSTAmount
                            , local.sasc_code as Local_Category, nonlocal.sasc_code as NonLocal_Category, hsd.sahd_type
                            from  sas_hostelstrDetails hsd 
                            inner join SAS_FeeTypes ft on ft.saft_code = hsd.saft_code
                            left join (select saha_amount,  safa_gstamount, sahs_code, saft_code, sasc_code from sas_hostelstrAmount where sas_hostelstrAmount.sasc_code in ('Local', 'W')  )as local on local.sahs_code = hsd.sahs_code and local.saft_code = hsd.saft_code
                            left join (select saha_amount,  safa_gstamount, sahs_code, saft_code, sasc_code from sas_hostelstrAmount where sas_hostelstrAmount.sasc_code in ('International', 'BW')  )as nonlocal on nonlocal.sahs_code = hsd.sahs_code and nonlocal.saft_code = hsd.saft_code
                            WHERE hsd.SAHS_Code = @SAHS_Code";

            sqlCmd = sqlCmd + " order by hsd.saft_code";

            try
            {
                if (!FormHelp.IsBlank(sqlCmd))
                {
                    DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString);
                    _DatabaseFactory.AddInParameter(ref cmd, "@SAHS_Code", DbType.String, argEn.HostelStructureCode);
                    _DbParameterCollection = cmd.Parameters;

                    using (IDataReader loReader = _DatabaseFactory.GetIDataReader(Helper.GetDataBaseType, cmd,
                                                                                  DataBaseConnectionString, sqlCmd, _DbParameterCollection).CreateDataReader())
                    {
                        HostelStrAmountDAL loHostelStrAmt   = new HostelStrAmountDAL();
                        HostelStrAmountEn  loHostelStrAmtEn = new HostelStrAmountEn();
                        while (loReader.Read())
                        {
                            HostelStructEn loItemDetails = new HostelStructEn();
                            loItemDetails.HostelStructureCode = GetValue <string>(loReader, "SAHS_Code");
                            loItemDetails.FTCode             = GetValue <string>(loReader, "saft_code");
                            loItemDetails.Description        = GetValue <string>(loReader, "saft_desc");
                            loItemDetails.LocalAmount        = GetValue <double>(loReader, "Local_Amount");
                            loItemDetails.LocalGSTAmount     = GetValue <double>(loReader, "Local_GSTAmount");
                            loItemDetails.NonLocalAmount     = GetValue <double>(loReader, "NonLocal_Amount");
                            loItemDetails.NonLocalGSTAmount  = GetValue <double>(loReader, "NonLocal_GSTAmount");
                            loItemDetails.TaxId              = GetValue <int>(loReader, "safs_taxmode");
                            loItemDetails.NonLocalTempAmount = loItemDetails.NonLocalAmount - loItemDetails.NonLocalGSTAmount;
                            loItemDetails.LocalTempAmount    = loItemDetails.LocalAmount - loItemDetails.LocalGSTAmount;
                            loItemDetails.LocalCategory      = GetValue <string>(loReader, "Local_Category");
                            loItemDetails.NonLocalCategory   = GetValue <string>(loReader, "NonLocal_Category");
                            loItemDetails.FeeCategory        = GetValue <string>(loReader, "sahd_type");
                            loItemDetails.Priority           = GetValue <int>(loReader, "sahd_priority");
                            loEnList.Add(loItemDetails);
                        }
                        loReader.Close();
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(loEnList);
        }
Ejemplo n.º 6
0
        /// <summary>
        /// Method to Update HostelStructure
        /// </summary>
        /// <param name="argEn">HostelStructure Entity is an Input.</param>
        /// <returns>Returns Boolean</returns>
        //public bool Update(HostelStructEn argEn)
        //{
        //    bool lbRes = false;
        //    int iOut = 0;
        //    string sqlCmd = "Select count(*) as cnt From SAS_HostelStruct WHERE SAHS_Code != @SAHS_Code and SAHB_Code=@SAHB_Code and SAHB_Block=@SAHB_Block and SAHB_RoomTYpe=@SAHB_RoomTYpe";
        //    try
        //    {
        //        if (!FormHelp.IsBlank(sqlCmd))
        //        {
        //            DbCommand cmdSel = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString);
        //            _DatabaseFactory.AddInParameter(ref cmdSel, "@SAHS_Code", DbType.String, argEn.HostelStructureCode);
        //            _DatabaseFactory.AddInParameter(ref cmdSel, "@SAHB_Block", DbType.String, argEn.Block);
        //            _DatabaseFactory.AddInParameter(ref cmdSel, "@SAHB_Code", DbType.String, argEn.Code);
        //            _DatabaseFactory.AddInParameter(ref cmdSel, "@SAHB_RoomTYpe", DbType.String, argEn.RoomTYpe);
        //            _DbParameterCollection = cmdSel.Parameters;

        //            using (IDataReader dr = _DatabaseFactory.GetIDataReader(Helper.GetDataBaseType, cmdSel,
        //              DataBaseConnectionString, sqlCmd, _DbParameterCollection).CreateDataReader())
        //            {

        //                if (dr.Read())
        //                    iOut = clsGeneric.NullToInteger(dr["cnt"]);
        //                if (iOut > 0)
        //                    throw new Exception("Record Already Exist");
        //            }
        //         }
        //            if (iOut == 0)
        //            {
        //                sqlCmd = "UPDATE SAS_HostelStruct SET SAHS_Code = @SAHS_Code, SAHB_Code = @SAHB_Code, SAHB_Block = @SAHB_Block, SAHB_RoomTYpe = @SAHB_RoomTYpe, SAHS_EffectFm = @SAHS_EffectFm, SAFS_Status = @SAFS_Status, SAHS_UpdatedUser = @SAHS_UpdatedUser, SAHS_UpdatedDtTm = @SAHS_UpdatedDtTm WHERE SAHS_Code = @SAHS_Code";
        //                if (!FormHelp.IsBlank(sqlCmd))
        //                {
        //                    DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString);
        //                    _DatabaseFactory.AddInParameter(ref cmd, "@SAHS_Code", DbType.String, argEn.HostelStructureCode);
        //                    _DatabaseFactory.AddInParameter(ref cmd, "@SAHB_Code", DbType.String, argEn.Code);
        //                    _DatabaseFactory.AddInParameter(ref cmd, "@SAHB_Block", DbType.String, argEn.Block);
        //                    _DatabaseFactory.AddInParameter(ref cmd, "@SAHB_RoomTYpe", DbType.String, argEn.RoomTYpe);
        //                    _DatabaseFactory.AddInParameter(ref cmd, "@SAHS_EffectFm", DbType.String, argEn.EffectFm);
        //                    _DatabaseFactory.AddInParameter(ref cmd, "@SAFS_Status", DbType.Boolean, argEn.Status);
        //                    _DatabaseFactory.AddInParameter(ref cmd, "@SAHS_UpdatedUser", DbType.String, argEn.UpdatedUser);
        //                    _DatabaseFactory.AddInParameter(ref cmd, "@SAHS_UpdatedDtTm", DbType.String, argEn.UpdatedDtTm);
        //                    _DbParameterCollection = cmd.Parameters;

        //                    int liRowAffected = _DatabaseFactory.ExecuteNonQuery(Helper.GetDataBaseType, cmd,
        //                        DataBaseConnectionString, sqlCmd, _DbParameterCollection);

        //                    int i = 0;
        //                    int j = 0;
        //                    HostelStrDetailsEn loHstDet = new HostelStrDetailsEn();
        //                    HostelStrAmountEn loHstAmt = new HostelStrAmountEn();
        //                    HostelStrDetailsDAL loHstrDal = new HostelStrDetailsDAL();
        //                    HostelStrAmountDAL loHstrAmDal = new HostelStrAmountDAL();
        //                    loHstAmt.HSCode = argEn.HostelStructureCode;
        //                    loHstDet.HSCode = argEn.HostelStructureCode;
        //                    //Deleting the existing hostel feeDetails & amounts
        //                    loHstrDal.Delete(loHstDet);
        //                    loHstrAmDal.Delete(loHstAmt);
        //                    while (i < argEn.lstHFeeSD.Count)
        //                    {
        //                        //inserting new hostel feeDetails
        //                        argEn.lstHFeeSD[i].HSCode = argEn.HostelStructureCode;
        //                        loHstrDal.Insert(argEn.lstHFeeSD[i]);
        //                        while (j < argEn.lstHFeeSD[i].ListFeeAmount.Count)
        //                        {
        //                            //inserting new hostel feeAmounts
        //                            argEn.lstHFeeSD[i].ListFeeAmount[j].HSCode = argEn.HostelStructureCode;
        //                            loHstrAmDal.Insert(argEn.lstHFeeSD[i].ListFeeAmount[j]);
        //                            j = j + 1;
        //                        }
        //                        i = i + 1;
        //                    }
        //                    if (liRowAffected > -1)
        //                        lbRes = true;
        //                    else
        //                        throw new Exception("Update Failed! No Row has been updated...");
        //                }
        //            }
        //        }

        //    catch (Exception ex)
        //    {
        //        throw ex;
        //    }
        //    return lbRes;
        //}

        /// <summary>
        /// Method to Update HostelStructure
        /// </summary>
        /// <param name="argEn">HostelStructure Entity is an Input.</param>
        /// <returns>Returns Boolean</returns>
        public bool Update(HostelStructEn argEn)
        {
            bool lbRes = false;

            lbRes = Delete(argEn);
            if (lbRes)
            {
                Insert(argEn, false);
            }
            return(lbRes);
        }
Ejemplo n.º 7
0
 /// <summary>
 /// Method to Get HostelStructucture Entity
 /// </summary>
 /// <param name="argEn">HostelStructucture Entity is an Input.HostelStuctureCode as Input Property.</param>
 /// <returns>Returns HostelStructucture Entity</returns>
 public HostelStructEn GetItem(HostelStructEn argEn)
 {
     try
     {
         HostelStructDAL loDs = new HostelStructDAL();
         return(loDs.GetItem(argEn));
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Ejemplo n.º 8
0
 /// <summary>
 /// Method to Get List of Active or Inactive Hostels
 /// </summary>
 /// <param name="argEn">HostelStructure Entity is an Input.RoomType,Code,Block and Status are Input Properties.</param>
 /// <returns>Returns List of HostelStructure</returns>
 public List <HostelStructEn> GetHostelList(HostelStructEn argEn)
 {
     try
     {
         HostelStructDAL loDs = new HostelStructDAL();
         return(loDs.GetHostelList(argEn));
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Ejemplo n.º 9
0
 /// <summary>
 /// Method to Check Validation
 /// </summary>
 /// <param name="argEn">HostelStructure Entity is as Input.</param>
 /// <returns>Returns a Boolean</returns>
 public bool IsValid(HostelStructEn argEn)
 {
     try
     {
         if (argEn.HostelStructureCode == null || argEn.HostelStructureCode.ToString().Length <= 0)
         {
             throw new Exception("HostelStructureCode Is Required!");
         }
         return(true);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Ejemplo n.º 10
0
        /// <summary>
        /// Method to Load HostelStructure Entity
        /// </summary>
        /// <param name="argReader">IDataReader Object is an Input.</param>
        /// <returns>Returns HostelStructure Entity</returns>
        private HostelStructEn LoadObject(IDataReader argReader)
        {
            HostelStructEn loItem = new HostelStructEn();

            loItem.HostelStructureCode = GetValue <string>(argReader, "SAHS_Code");
            loItem.Code        = GetValue <string>(argReader, "SAHB_Code");
            loItem.Block       = GetValue <string>(argReader, "SAHB_Block");
            loItem.RoomTYpe    = GetValue <string>(argReader, "SAHB_RoomTYpe");
            loItem.EffectFm    = GetValue <string>(argReader, "SAHS_EffectFm");
            loItem.Status      = GetValue <bool>(argReader, "SAFS_Status");
            loItem.UpdatedUser = GetValue <string>(argReader, "SAHS_UpdatedUser");
            loItem.UpdatedDtTm = GetValue <string>(argReader, "SAHS_UpdatedDtTm");

            return(loItem);
        }
Ejemplo n.º 11
0
        /// <summary>
        /// Method to Insert HostelStructure
        /// </summary>
        /// <param name="argEn">HostelStructure Entity is an Input.</param>
        /// <returns>Returns Boolean</returns>
        public bool Insert(HostelStructEn argEn)
        {
            bool flag;

            using (TransactionScope ts = new TransactionScope())
            {
                try
                {
                    HostelStructDAL loDs = new HostelStructDAL();
                    flag = loDs.Insert(argEn);
                    ts.Complete();
                }
                catch (Exception ex)
                {
                    throw ex;
                }
            }
            return(flag);
        }
Ejemplo n.º 12
0
        /// <summary>
        /// Method to Delete HostelStructure
        /// </summary>
        /// <param name="argEn">HostelStructure Entity is an Input.</param>
        /// <returns>Returns Boolean</returns>
        public bool Delete(HostelStructEn argEn)
        {
            bool   lbRes  = false;
            string sqlCmd = "DELETE FROM SAS_HostelStruct WHERE SAHS_Code = @SAHS_Code";

            try
            {
                if (!FormHelp.IsBlank(sqlCmd))
                {
                    DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString);
                    _DatabaseFactory.AddInParameter(ref cmd, "@SAHS_Code", DbType.String, argEn.HostelStructureCode);
                    _DbParameterCollection = cmd.Parameters;

                    HostelStrDetailsEn  loHstrDet    = new HostelStrDetailsEn();
                    HostelStrDetailsDAL loHstrDetDal = new HostelStrDetailsDAL();
                    HostelStrAmountEn   loHstrAmt    = new HostelStrAmountEn();
                    HostelStrAmountDAL  loHstAmtDal  = new HostelStrAmountDAL();
                    loHstrAmt.HSCode = argEn.HostelStructureCode;
                    loHstrDet.HSCode = argEn.HostelStructureCode;
                    loHstAmtDal.Delete(loHstrAmt);
                    loHstrDetDal.Delete(loHstrDet);

                    int liRowAffected = _DatabaseFactory.ExecuteNonQuery(Helper.GetDataBaseType, cmd,
                                                                         DataBaseConnectionString, sqlCmd, _DbParameterCollection);

                    if (liRowAffected > -1)
                    {
                        lbRes = true;
                    }
                    else
                    {
                        throw new Exception("Deletion Failed! No Row has been updated...");
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(lbRes);
        }
Ejemplo n.º 13
0
        /// <summary>
        /// Method to Get List of HostelSructure Feelist
        /// </summary>
        /// <param name="argEn">HostelStructure Entity is an Input.HostelStructureCode,Code,Block and Status are Input Properties.</param>
        /// <returns>Returns List of HostelStructure</returns>
        public List <HostelStructEn> GetHostelFeeList(HostelStructEn argEn)
        {
            List <HostelStructEn> loEnList = new List <HostelStructEn>();

            argEn.HostelStructureCode = argEn.HostelStructureCode.Replace("*", "%");
            argEn.Code  = argEn.Code.Replace("*", "%");
            argEn.Block = argEn.Block.Replace("*", "%");

            string sqlCmd = "SELECT SAS_HostelStruct.SAHS_Code, SAS_HostelStruct.SAHB_Code, SAS_HostelStruct.SAHB_Block, " +
                            " SAS_HostelStruct.SAHB_RoomTYpe, SAS_HostelStruct.SAHS_EffectFm, SAS_HostelStruct.SAFS_Status, " +
                            " SAS_HostelStruct.SAHS_UpdatedUser, SAS_HostelStruct.SAHS_UpdatedDtTm, SAS_HostelStrDetails.SAHD_Code, " +
                            " SAS_HostelStrDetails.SAFT_Code, SAS_FeeTypes.SAFT_Desc, SAS_HostelStrDetails.SAHD_Type, " +
                            " SAS_HostelStrDetails.SAHD_Priority, SAS_HostelStrAmount.SASC_Code, SAS_StudentCategory.SASC_Code AS Expr1, " +
                            " SAS_StudentCategory.SASC_Desc, SAS_HostelStrAmount.SAHA_Amount " +
                            " FROM  SAS_HostelStruct INNER JOIN " +
                            " SAS_HostelStrDetails ON SAS_HostelStruct.SAHS_Code = SAS_HostelStrDetails.SAHS_Code INNER JOIN " +
                            " SAS_HostelStrAmount ON SAS_HostelStruct.SAHS_Code = SAS_HostelStrAmount.SAHS_Code AND " +
                            " SAS_HostelStrDetails.SAFT_Code = SAS_HostelStrAmount.SAFT_Code INNER JOIN " +
                            " SAS_FeeTypes ON SAS_HostelStrDetails.SAFT_Code = SAS_FeeTypes.SAFT_Code INNER JOIN " +
                            " SAS_StudentCategory ON SAS_HostelStrAmount.SASC_Code = SAS_StudentCategory.SASC_Code where SAS_HostelStruct.SAHS_Code <> '0'";

            if (argEn.HostelStructureCode.Length != 0)
            {
                sqlCmd = sqlCmd + " SAS_HostelStruct.SAHS_Code like '" + argEn.HostelStructureCode + "'";
            }
            if (argEn.Code.Length != 0)
            {
                sqlCmd = sqlCmd + " SAS_HostelStruct.SAHB_Code like '" + argEn.Code + "'";
            }
            if (argEn.Block.Length != 0)
            {
                sqlCmd = sqlCmd + " SAS_HostelStruct.SAHB_Block '" + argEn.Block + "'";
            }
            //if (argEn.Status == true) sqlCmd = sqlCmd + " SAS_HostelStruct.SAFS_Status = 1";
            if (argEn.Status == true)
            {
                sqlCmd = sqlCmd + " SAS_HostelStruct.SAFS_Status = 'true'";
            }
            //if (argEn.Status == false) sqlCmd = sqlCmd + " SAS_HostelStruct.SAFS_Status = 0 ";
            if (argEn.Status == false)
            {
                sqlCmd = sqlCmd + " SAS_HostelStruct.SAFS_Status = 'false' ";
            }

            try
            {
                if (!FormHelp.IsBlank(sqlCmd))
                {
                    using (IDataReader loReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType,
                                                                                 DataBaseConnectionString, sqlCmd).CreateDataReader())
                    {
                        while (loReader.Read())
                        {
                            HostelStructEn loItem = LoadObject(loReader);
                            loEnList.Add(loItem);
                        }
                        loReader.Close();
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(loEnList);
        }
Ejemplo n.º 14
0
        /// <summary>
        /// Method to Insert HostelStructure
        /// </summary>
        /// <param name="argEn">HostelStructure Entity is an Input.</param>
        /// <returns>Returns Boolean</returns>
        //public bool Insert(HostelStructEn argEn)
        //{
        //    bool lbRes = false;
        //    int iOut = 0;
        //    string sqlCmd = "Select count(*) as cnt From SAS_HostelStruct WHERE SAHS_Code != @SAHS_Code and SAHB_Code=@SAHB_Code and SAHB_Block=@SAHB_Block and SAHB_RoomTYpe=@SAHB_RoomTYpe";
        //    try
        //    {
        //        if (!FormHelp.IsBlank(sqlCmd))
        //        {
        //            DbCommand cmdSel = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString);
        //            _DatabaseFactory.AddInParameter(ref cmdSel, "@SAHS_Code", DbType.String, argEn.HostelStructureCode);
        //            _DatabaseFactory.AddInParameter(ref cmdSel, "@SAHB_Block", DbType.String, argEn.Block);
        //            _DatabaseFactory.AddInParameter(ref cmdSel, "@SAHB_Code", DbType.String, argEn.Code);
        //            _DatabaseFactory.AddInParameter(ref cmdSel, "@SAHB_RoomTYpe", DbType.String, argEn.RoomTYpe);
        //            _DbParameterCollection = cmdSel.Parameters;

        //            using (IDataReader dr = _DatabaseFactory.GetIDataReader(Helper.GetDataBaseType, cmdSel,
        //                DataBaseConnectionString, sqlCmd, _DbParameterCollection).CreateDataReader())
        //            {
        //                if (dr.Read())
        //                    iOut = clsGeneric.NullToInteger(dr["cnt"]);
        //                if (iOut > 0)
        //                    throw new Exception("Record Already Exist");
        //            }
        //        }
        //        if (iOut == 0)
        //        {
        //            sqlCmd = "INSERT INTO SAS_HostelStruct(SAHS_Code,SAHB_Code,SAHB_Block,SAHB_RoomTYpe,SAHS_EffectFm,SAFS_Status,SAHS_UpdatedUser,SAHS_UpdatedDtTm) VALUES (@SAHS_Code,@SAHB_Code,@SAHB_Block,@SAHB_RoomTYpe,@SAHS_EffectFm,@SAFS_Status,@SAHS_UpdatedUser,@SAHS_UpdatedDtTm) ";

        //            if (!FormHelp.IsBlank(sqlCmd))
        //            {

        //                argEn.HostelStructureCode = GetAutoNumber("HostelCode");
        //                DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString);
        //                _DatabaseFactory.AddInParameter(ref cmd, "@SAHS_Code", DbType.String, argEn.HostelStructureCode);
        //                _DatabaseFactory.AddInParameter(ref cmd, "@SAHB_Code", DbType.String, argEn.Code);
        //                _DatabaseFactory.AddInParameter(ref cmd, "@SAHB_Block", DbType.String, argEn.Block);
        //                _DatabaseFactory.AddInParameter(ref cmd, "@SAHB_RoomTYpe", DbType.String, argEn.RoomTYpe);
        //                _DatabaseFactory.AddInParameter(ref cmd, "@SAHS_EffectFm", DbType.String, argEn.EffectFm);
        //                _DatabaseFactory.AddInParameter(ref cmd, "@SAFS_Status", DbType.Boolean, argEn.Status);
        //                _DatabaseFactory.AddInParameter(ref cmd, "@SAHS_UpdatedUser", DbType.String, argEn.UpdatedUser);
        //                _DatabaseFactory.AddInParameter(ref cmd, "@SAHS_UpdatedDtTm", DbType.String, argEn.UpdatedDtTm);
        //                _DbParameterCollection = cmd.Parameters;

        //                int liRowAffected = _DatabaseFactory.ExecuteNonQuery(Helper.GetDataBaseType, cmd,
        //                        DataBaseConnectionString, sqlCmd, _DbParameterCollection);
        //                int i = 0;
        //                int j = 0;

        //                HostelStrDetailsDAL loHstrDal = new HostelStrDetailsDAL();
        //                HostelStrAmountDAL loHstrAmDal = new HostelStrAmountDAL();
        //                while (i < argEn.lstHFeeSD.Count)
        //                {
        //                    //inserting new hostel feeDetails
        //                    argEn.lstHFeeSD[i].HSCode = argEn.HostelStructureCode;
        //                    loHstrDal.Insert(argEn.lstHFeeSD[i]);
        //                    while (j < argEn.lstHFeeSD[i].ListFeeAmount.Count)
        //                    {
        //                        //inserting new hostel feeAmounts
        //                        argEn.lstHFeeSD[i].ListFeeAmount[j].HSCode = argEn.HostelStructureCode;
        //                        loHstrAmDal.Insert(argEn.lstHFeeSD[i].ListFeeAmount[j]);
        //                        j = j + 1;
        //                    }
        //                    i = i + 1;
        //                }
        //                if (liRowAffected > -1)
        //                    lbRes = true;
        //                else
        //                    throw new Exception("Insertion Failed! No Row has been updated...");
        //            }
        //        }
        //    }
        //    catch (Exception ex)
        //    {
        //        throw ex;
        //    }
        //    return lbRes;
        //}

        /// <summary>
        /// Method to Insert HostelStructure
        /// </summary>
        /// <param name="argEn">HostelStructure Entity is an Input.</param>
        /// <returns>Returns Boolean</returns>
        public bool Insert(HostelStructEn argEn, bool GenerateAutoNumber = true)
        {
            bool lbRes = false;
            int  iOut  = 0;
            //DO NOT USE SAHS_CODE TO CHECKING, CHECK COMPOSITE KEY ( SAHB_Code, SAHB_Block, SAHB_RoomTYpe)
            //string sqlCmd = "Select count(*) as cnt From SAS_HostelStruct WHERE SAHS_Code = @SAHS_Code and SAHB_Code=@SAHB_Code and SAHB_Block=@SAHB_Block and SAHB_RoomTYpe=@SAHB_RoomTYpe";
            string sqlCmd = "Select count(*) as cnt From SAS_HostelStruct WHERE SAHB_Code=@SAHB_Code and SAHB_Block=@SAHB_Block and SAHB_RoomTYpe=@SAHB_RoomTYpe";

            try
            {
                if (!FormHelp.IsBlank(sqlCmd))
                {
                    DbCommand cmdSel = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString);
                    // _DatabaseFactory.AddInParameter(ref cmdSel, "@SAHS_Code", DbType.String, argEn.HostelStructureCode);
                    _DatabaseFactory.AddInParameter(ref cmdSel, "@SAHB_Block", DbType.String, argEn.Block);
                    _DatabaseFactory.AddInParameter(ref cmdSel, "@SAHB_Code", DbType.String, argEn.Code);
                    _DatabaseFactory.AddInParameter(ref cmdSel, "@SAHB_RoomTYpe", DbType.String, argEn.RoomTYpe);
                    _DbParameterCollection = cmdSel.Parameters;

                    using (IDataReader dr = _DatabaseFactory.GetIDataReader(Helper.GetDataBaseType, cmdSel,
                                                                            DataBaseConnectionString, sqlCmd, _DbParameterCollection).CreateDataReader())
                    {
                        if (dr.Read())
                        {
                            iOut = clsGeneric.NullToInteger(dr["cnt"]);
                        }
                        if (iOut > 0)
                        {
                            throw new Exception("Record Already Exist");
                        }
                    }
                }
                if (iOut == 0)
                {
                    sqlCmd = "INSERT INTO SAS_HostelStruct(SAHS_Code,SAHB_Code,SAHB_Block,SAHB_RoomTYpe,SAHS_EffectFm,SAFS_Status,SAHS_UpdatedUser,SAHS_UpdatedDtTm) VALUES (@SAHS_Code,@SAHB_Code,@SAHB_Block,@SAHB_RoomTYpe,@SAHS_EffectFm,@SAFS_Status,@SAHS_UpdatedUser,@SAHS_UpdatedDtTm) ";

                    if (!FormHelp.IsBlank(sqlCmd))
                    {
                        if (GenerateAutoNumber)
                        {
                            argEn.HostelStructureCode = GetAutoNumber("HostelCode");
                        }
                        DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString);
                        _DatabaseFactory.AddInParameter(ref cmd, "@SAHS_Code", DbType.String, clsGeneric.NullToString(argEn.HostelStructureCode));
                        _DatabaseFactory.AddInParameter(ref cmd, "@SAHB_Code", DbType.String, clsGeneric.NullToString(argEn.Code));
                        _DatabaseFactory.AddInParameter(ref cmd, "@SAHB_Block", DbType.String, clsGeneric.NullToString(argEn.Block));
                        _DatabaseFactory.AddInParameter(ref cmd, "@SAHB_RoomTYpe", DbType.String, clsGeneric.NullToString(argEn.RoomTYpe));
                        _DatabaseFactory.AddInParameter(ref cmd, "@SAHS_EffectFm", DbType.String, clsGeneric.NullToString(argEn.EffectFm));
                        _DatabaseFactory.AddInParameter(ref cmd, "@SAFS_Status", DbType.Boolean, clsGeneric.NullToBoolean(argEn.Status));
                        _DatabaseFactory.AddInParameter(ref cmd, "@SAHS_UpdatedUser", DbType.String, clsGeneric.NullToString(argEn.UpdatedUser));
                        _DatabaseFactory.AddInParameter(ref cmd, "@SAHS_UpdatedDtTm", DbType.String, clsGeneric.NullToString(DateTime.Now.ToString("dd/MM/yyyy")));
                        _DbParameterCollection = cmd.Parameters;

                        int liRowAffected = _DatabaseFactory.ExecuteNonQuery(Helper.GetDataBaseType, cmd,
                                                                             DataBaseConnectionString, sqlCmd, _DbParameterCollection);
                        int i = 0;
                        int j = 0;

                        HostelStrDetailsDAL loHstrDal   = new HostelStrDetailsDAL();
                        HostelStrAmountDAL  loHstrAmDal = new HostelStrAmountDAL();
                        while (i < argEn.lstHFeeSD.Count)
                        {
                            //inserting new hostel feeDetails
                            argEn.lstHFeeSD[i].HSCode = argEn.HostelStructureCode;
                            loHstrDal.Insert(argEn.lstHFeeSD[i]);
                            j = 0;
                            while (j < argEn.lstHFeeSD[i].ListFeeAmount.Count)
                            {
                                //inserting new hostel feeAmounts
                                argEn.lstHFeeSD[i].ListFeeAmount[j].HSCode = argEn.HostelStructureCode;
                                loHstrAmDal.Insert(argEn.lstHFeeSD[i].ListFeeAmount[j]);
                                j = j + 1;
                            }
                            i = i + 1;
                        }
                        if (liRowAffected > -1)
                        {
                            lbRes = true;
                        }
                        else
                        {
                            throw new Exception("Insertion Failed! No Row has been updated...");
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(lbRes);
        }