Exemple #1
0
        /// <summary>
        /// Method to Insert Kolej
        /// </summary>
        /// <param name="argEn">Kolej Entity is an Input.</param>
        /// <returns>Returns Boolean</returns>
        public bool Insert(KolejEn argEn)
        {
            //variable declarations - Start
            bool   Result = false;
            string SqlStatement = null; int RecordsSaved = 0;

            //variable declarations - Stop

            try
            {
                //build sqlstatement - Start
                SqlStatement  = "Select SAKO_Code, SAKO_Description From SAS_Kolej WHERE ";
                SqlStatement += " SAKO_Code = " + clsGeneric.AddQuotes(argEn.SAKO_Code);
                SqlStatement += " OR SAKO_Description = " + clsGeneric.AddQuotes(argEn.SAKO_Description);
                //build sqlstatement - Stop

                //if no duplicate records - Start
                if (_DatabaseFactory.ExecuteReader(Helper.GetDataBaseType,
                                                   DataBaseConnectionString, SqlStatement).Rows.Count == 0)
                {
                    //Build Sql Columns

                    SqlStatement  = "INSERT INTO sas_kolej VALUES (" + clsGeneric.AddQuotes(argEn.SAKO_Code);
                    SqlStatement += "," + clsGeneric.AddQuotes(argEn.SAKO_Description) + ")";

                    //Save Details to Database - Start
                    RecordsSaved = _DatabaseFactory.ExecuteSqlStatement(Helper.GetDataBaseType,
                                                                        DataBaseConnectionString, SqlStatement);
                    //Save Details to Database - Stop

                    //if records saved successfully - Start
                    if (RecordsSaved > -1)
                    {
                        Result = true;
                    }
                    else
                    {
                        throw new Exception("Insertion Failed! No Row has been updated...");
                    }
                    //if records saved successfully - Stop
                }
                //if no duplicate records - Stop

                return(Result);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Exemple #2
0
        /// <summary>
        /// Method to Get List of all Kolej
        /// </summary>
        /// <param name="argEn">Kolej Entity is an Input.</param>
        /// <returns>Returns List of Kolej</returns>
        public List <KolejEn> GetKolejList(KolejEn argEn)
        {
            //create instances
            List <KolejEn> KolejList = new List <KolejEn>();

            //variable declarations
            string SqlStatement = null;

            try
            {
                //Replace wildchars - Start
                argEn.SAKO_Code        = argEn.SAKO_Code.Replace("*", "");
                argEn.SAKO_Description = argEn.SAKO_Description.Replace("*", "");
                //Replace wildchars - Stop

                //Build Sqlstatement - Start
                SqlStatement  = "select * from SAS_Kolej  WHERE SAKO_Code  <> '0'";
                SqlStatement += " and SAKO_Code like '%" + argEn.SAKO_Code + "%'";
                SqlStatement += " and SAKO_Description like '%";
                SqlStatement += argEn.SAKO_Description + "%' order by SAKO_Code";
                //Build Sqlstatement - Stop

                //Get User Login Details - Start
                IDataReader _IDataReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType,
                                                                          DataBaseConnectionString, SqlStatement).CreateDataReader();
                //Get User Login Details - Stop

                //if details available - Start
                if (_IDataReader != null)
                {
                    while (_IDataReader.Read())
                    {
                        KolejEn _KolejEn = LoadObject(_IDataReader);
                        KolejList.Add(_KolejEn);
                    }

                    _IDataReader.Close();
                    _IDataReader.Dispose();

                    return(KolejList);
                }
                //if details available - Stop

                return(null);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Exemple #3
0
 /// <summary>
 /// Method to Check Validation
 /// </summary>
 /// <param name="argEn">Kolej Entity is as Input.</param>
 /// <returns>Returns a Boolean</returns>
 public bool IsValid(KolejEn argEn)
 {
     try
     {
         if (argEn.SAKO_Code == null || argEn.SAKO_Code.ToString().Length <= 0)
         {
             throw new Exception("SAKO_Code Is Required!");
         }
         if (argEn.SAKO_Description == null || argEn.SAKO_Description.ToString().Length <= 0)
         {
             throw new Exception("SAKO_Description Is Required!");
         }
         return(true);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Exemple #4
0
        /// <summary>
        /// Method to Delete Kolej
        /// </summary>
        /// <param name="argEn">Kolej Entity is an Input.</param>
        /// <returns>Returns Boolean</returns>
        public bool Delete(KolejEn argEn)
        {
            bool flag;

            using (TransactionScope ts = new TransactionScope())
            {
                try
                {
                    KolejDAL loDs = new KolejDAL();
                    flag = loDs.Delete(argEn);
                    ts.Complete();
                }
                catch (Exception ex)
                {
                    throw ex;
                }
            }
            return(flag);
        }
Exemple #5
0
        /// <summary>
        /// Method to Get Kolej Entity
        /// </summary>
        /// <param name="argEn">Kolej Entity is an Input.SAKO_Code as Input Property.</param>
        /// <returns>Returns Kolej Entity</returns>
        public KolejEn GetItem(KolejEn argEn)
        {
            //create instances
            KolejEn _KolejEn = new KolejEn();

            //vraiable declarations
            string SqlStatement = null;

            try
            {
                //Build Sql Statement - Start
                SqlStatement  = "Select * FROM SAS_Kolej WHERE SAKO_Code = ";
                SqlStatement += clsGeneric.AddQuotes(argEn.SAKO_Code);
                //Build Sql Statement - Stop

                //Get User Login Details - Start
                IDataReader _IDataReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType,
                                                                          DataBaseConnectionString, SqlStatement).CreateDataReader();
                //Get User Login Details - Stop

                //if details available - Start
                if (_IDataReader != null)
                {
                    while (_IDataReader.Read())
                    {
                        _KolejEn = LoadObject(_IDataReader);
                    }

                    _IDataReader.Close();
                    _IDataReader.Dispose();

                    return(_KolejEn);
                }
                //if details available - Stop

                return(null);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Exemple #6
0
        /// <summary>
        /// Method to Get List of Kolej
        /// </summary>
        /// <param name="argEn">Kolej Entity is an Input.</param>
        /// <returns>Returns List of Kolej</returns>
        public List <KolejEn> GetListKokorikulum(KolejEn argEn)
        {
            //create instances
            List <KolejEn> KolejList = new List <KolejEn>();

            //variable declarations
            string SqlStatement = null;

            try
            {
                //build sql statement
                SqlStatement = "SELECT * FROM sas_kokorikulum where Sako_code ='" + argEn.SAKO_Code + "'";

                //Get User Login Details - Start
                IDataReader _IDataReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType,
                                                                          DataBaseConnectionString, SqlStatement).CreateDataReader();
                //Get User Login Details - Stop

                //if details available - Start
                if (_IDataReader != null)
                {
                    while (_IDataReader.Read())
                    {
                        KolejEn _KolejEn = LoadObject(_IDataReader);
                        KolejList.Add(_KolejEn);
                    }

                    _IDataReader.Close();
                    _IDataReader.Dispose();

                    return(KolejList);
                }
                //if details available - Stop

                return(null);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Exemple #7
0
        /// <summary>
        /// Method to Update Kolej
        /// </summary>
        /// <param name="argEn">Kolej Entity is an Input.</param>
        /// <returns>Returns Boolean</returns>
        public bool Delete(KolejEn argEn)
        {
            //variable declarations
            string SqlStatement = null; int HasRows = 0; int RecordsSaved = 0; bool Result = false;

            try
            {
                //Build Sqlstatement - Start
                SqlStatement  = "select sum(rows) as total from(SELECT COUNT(*) AS rows FROM  SAS_Student where SAKO_Code = ";
                SqlStatement += clsGeneric.AddQuotes(argEn.SAKO_Code) + " UNION ALL ";
                SqlStatement += "select count(*) as rows from SAS_Block WHERE SAKO_Code = ";
                SqlStatement += clsGeneric.AddQuotes(argEn.SAKO_Code) + ") AS U";
                //Build Sqlstatement - Stop

                //Get User Login Details - Start
                IDataReader _IDataReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType,
                                                                          DataBaseConnectionString, SqlStatement).CreateDataReader();
                //Get User Login Details - Stop

                //if details available - Start
                if (_IDataReader != null)
                {
                    if (_IDataReader.Read())
                    {
                        HasRows = clsGeneric.NullToInteger(_IDataReader["total"]);
                        if (HasRows > 0)
                        {
                            throw new Exception("Record Already in Use");
                        }
                    }

                    _IDataReader.Close();
                    _IDataReader.Dispose();

                    //if record not used - Start
                    if (HasRows == 0)
                    {
                        //build sql statement - Start
                        SqlStatement  = "DELETE FROM SAS_Kolej WHERE SAKO_Code = ";
                        SqlStatement += clsGeneric.AddQuotes(argEn.SAKO_Code);
                        //build sql statement - Stop

                        //Save Details to Database
                        RecordsSaved = _DatabaseFactory.ExecuteSqlStatement(Helper.GetDataBaseType,
                                                                            DataBaseConnectionString, SqlStatement);

                        //if records saved successfully - Start
                        if (RecordsSaved > -1)
                        {
                            Result = true;
                        }
                        else
                        {
                            throw new Exception("Delete Failed! No Row has been deleted...");
                        }
                        //if records saved successfully - Stop
                    }
                    //if record not used - Sto

                    return(Result);
                }
                //if details available - Stop

                return(false);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }