コード例 #1
0
ファイル: LocationsDAO.cs プロジェクト: nirshandileep/WebZent
        public bool DeleteLocation(Location objLocation)
        {
            bool result = false;
            try
            {
                Database db = DatabaseFactory.CreateDatabase(Constant.Database_Connection_Name);
                DbCommand dbCommand = db.GetStoredProcCommand(Constant.SP_Location_Delete);

                db.AddInParameter(dbCommand, "@iBranchId", DbType.Int32, objLocation.BranchId);

                if (db.ExecuteNonQuery(dbCommand) > 0)
                {
                    result = true;

                }
            }
            catch (System.Exception ex)
            {
                ex.Data.Add("BusinessLayerException", this.GetType().ToString() + Constant.Error_Seperator + "public bool InsertLocation()");
                throw ex;
            }
            return result;
        }
コード例 #2
0
ファイル: LocationsDAO.cs プロジェクト: nirshandileep/WebZent
        public bool AddLocation(Location objLocation)
        {
            bool result = false;
            try
            {
                Database db = DatabaseFactory.CreateDatabase(Constant.Database_Connection_Name);
                DbCommand dbCommand = db.GetStoredProcCommand(Constant.SP_Location_InsertLocation);

                db.AddInParameter(dbCommand, "@sBranchCode", DbType.String, objLocation.BranchCode);
                db.AddInParameter(dbCommand, "@sBranchName", DbType.String, objLocation.BranchName);
                db.AddInParameter(dbCommand, "@sAddress1", DbType.String, objLocation.Address1);
                db.AddInParameter(dbCommand, "@sAddress2", DbType.String, objLocation.Address2);
                db.AddInParameter(dbCommand, "@sTelephone", DbType.String, objLocation.Telephone);
                db.AddInParameter(dbCommand, "@sContactName", DbType.String, objLocation.ContactName);
                db.AddInParameter(dbCommand, "@bIsActive", DbType.Boolean, objLocation.IsActive);
                db.AddInParameter(dbCommand, "@sInvCode", DbType.String, objLocation.InvPrefix);

                db.AddOutParameter(dbCommand, "@iBranchId", DbType.Int32, 4);

                if (db.ExecuteNonQuery(dbCommand) > 0)
                {
                    int newLocID = (int)db.GetParameterValue(dbCommand, "@iBranchId");
                    if (newLocID > 0)
                    {
                        objLocation.BranchId = newLocID;
                        result = true;
                    }
                }
            }
            catch (System.Exception ex)
            {
                ex.Data.Add("BusinessLayerException", this.GetType().ToString() + Constant.Error_Seperator + "public bool InsertLocation()");
                throw ex;
            }
            return result;
        }
コード例 #3
0
ファイル: LocationsDAO.cs プロジェクト: nirshandileep/WebZent
        public bool GetLocationByID(Location objLocation)
        {
            bool result = false;
            try
            {
                Database db = DatabaseFactory.CreateDatabase(Constant.Database_Connection_Name);
                DbCommand dbCommand = db.GetStoredProcCommand(Constant.SP_Location_GetLocationByID);

                db.AddInParameter(dbCommand, "@iBranchId", DbType.Int32, objLocation.BranchId);

                IDataReader reader = db.ExecuteReader(dbCommand);
                if (reader != null)
                {
                    while (reader.Read())
                    {
                        objLocation.BranchId = reader["BranchId"] != DBNull.Value ? Convert.ToInt32(reader["BranchId"].ToString()) : 0;
                        objLocation.BranchCode = reader["BranchCode"].ToString();
                        objLocation.BranchName = reader["BranchName"].ToString();
                        objLocation.Address1 = reader["Address1"].ToString();
                        objLocation.Address2 = reader["Address2"].ToString();
                        objLocation.Telephone = reader["Telephone"].ToString();
                        objLocation.ContactName = reader["ContactName"].ToString();
                        objLocation.IsActive = reader["IsActive"] != DBNull.Value ? Convert.ToBoolean(reader["IsActive"].ToString()) : false;
                        objLocation.InvPrefix = reader["InvPrefix"] != DBNull.Value ? reader["InvPrefix"].ToString().ToString() : string.Empty;

                        result = true;
                    }
                }

            }
            catch(System.Exception ex)
            {
                throw ex;
            }
            return result;
        }
コード例 #4
0
ファイル: LocationsDAO.cs プロジェクト: nirshandileep/WebZent
        public DataSet SearchLocation(Location objLocation)
        {
            try
            {
                Database db = DatabaseFactory.CreateDatabase(Constant.Database_Connection_Name);
                DbCommand dbCommand = db.GetStoredProcCommand(Constant.SP_Location_SearchLocations);

                db.AddInParameter(dbCommand, "@sBranchCode", DbType.String, objLocation.BranchCode);
                db.AddInParameter(dbCommand, "@sBranchName", DbType.String, objLocation.BranchName);
                db.AddInParameter(dbCommand, "@bIsActive", DbType.Boolean, objLocation.IsActive);

                return db.ExecuteDataSet(dbCommand);

            }
            catch (System.Exception ex)
            {
                throw ex;
                return null;
            }
        }