Пример #1
0
        public List <StorageModel> GetStorageList(long TenantID, string OrderBy, string SortBy)
        {
            ShomaRMEntities     db    = new ShomaRMEntities();
            List <StorageModel> model = new List <StorageModel>();

            try
            {
                DataTable dtTable = new DataTable();
                using (var cmd = db.Database.Connection.CreateCommand())
                {
                    db.Database.Connection.Open();
                    cmd.CommandText = "usp_Get_Storage";
                    cmd.CommandType = CommandType.StoredProcedure;

                    DbParameter paramTID = cmd.CreateParameter();
                    paramTID.ParameterName = "TenantID";
                    paramTID.Value         = TenantID;
                    cmd.Parameters.Add(paramTID);

                    DbParameter paramOB = cmd.CreateParameter();
                    paramOB.ParameterName = "OrderBy";
                    paramOB.Value         = OrderBy;
                    cmd.Parameters.Add(paramOB);

                    DbParameter paramSB = cmd.CreateParameter();
                    paramSB.ParameterName = "SortBy";
                    paramSB.Value         = SortBy;
                    cmd.Parameters.Add(paramSB);

                    DbDataAdapter da = DbProviderFactories.GetFactory("System.Data.SqlClient").CreateDataAdapter();
                    da.SelectCommand = cmd;
                    da.Fill(dtTable);
                    db.Database.Connection.Close();
                }
                foreach (DataRow dr in dtTable.Rows)
                {
                    StorageModel usm = new StorageModel();
                    usm.StorageID   = int.Parse(dr["StorageID"].ToString());
                    usm.PropertyID  = int.Parse(dr["PropertyID"].ToString());
                    usm.StorageName = dr["StorageName"].ToString();
                    usm.Charges     = Convert.ToDecimal(dr["Charges"].ToString());
                    usm.Description = dr["Description"].ToString();
                    usm.Type        = int.Parse(dr["Type"].ToString());
                    model.Add(usm);
                }
                db.Dispose();
                return(model.ToList());
            }
            catch (Exception ex)
            {
                db.Database.Connection.Close();
                throw ex;
            }
        }
Пример #2
0
        public StorageModel GetStorageData(int Id)
        {
            ShomaRMEntities db    = new ShomaRMEntities();
            StorageModel    model = new StorageModel();

            var GetStorageData = db.tbl_Storage.Where(p => p.StorageID == Id).FirstOrDefault();

            if (GetStorageData != null)
            {
                model.StorageID   = GetStorageData.StorageID;
                model.PropertyID  = GetStorageData.PropertyID;
                model.StorageName = GetStorageData.StorageName;
                model.Charges     = GetStorageData.Charges;
                model.Description = GetStorageData.Description;
            }
            model.StorageID = Id;
            return(model);
        }
Пример #3
0
        public StorageModel GetStorageInfo(int ID = 0)
        {
            ShomaRMEntities db    = new ShomaRMEntities();
            StorageModel    model = new StorageModel();

            model.StorageID   = 0;
            model.StorageName = "";

            var StorageInfo = db.tbl_Storage.Where(p => p.StorageID == StorageID).FirstOrDefault();

            if (StorageInfo != null)
            {
                model.StorageID   = StorageInfo.StorageID;
                model.PropertyID  = StorageInfo.PropertyID;
                model.StorageName = StorageInfo.StorageName;
                model.Charges     = StorageInfo.Charges;
                model.Description = StorageInfo.Description;
            }

            return(model);
        }
Пример #4
0
        public long SaveUpdateStorage(StorageModel model)
        {
            ShomaRMEntities db = new ShomaRMEntities();

            if (model.StorageID != 0)
            {
                var StorageInfo = db.tbl_Storage.Where(p => p.StorageID == model.StorageID).FirstOrDefault();
                if (StorageInfo != null)
                {
                    StorageInfo.PropertyID  = model.PropertyID;
                    StorageInfo.StorageName = model.StorageName;
                    StorageInfo.Charges     = model.Charges;
                    StorageInfo.Description = model.Description;
                    db.SaveChanges();
                }
                else
                {
                    throw new Exception(model.StorageName + " not exists in the system.");
                }
            }

            return(model.StorageID);
        }