public bool DeleteItem(PharmaBusinessObjects.Master.ItemMaster existingItem)
{
using (PharmaDBEntities context = new PharmaDBEntities())
{
int _result = 0;
Entity.ItemMaster existingItemDB = context.ItemMaster.Where(p => p.ItemCode == existingItem.ItemCode && p.Status).FirstOrDefault();
if (existingItemDB != null)
{
existingItemDB.Status = false;
existingItemDB.Status = existingItem.Status;
existingItemDB.ModifiedBy = this.LoggedInUser.Username;
existingItemDB.ModifiedOn = System.DateTime.Now;
}
_result = context.SaveChanges();
if (_result > 0)
{
return(true);
}
else
{
return(false);
}
}
}
public List <Entity.ItemMaster> GetItemMasterList()
{
try
{
List <Entity.ItemMaster> objList = new List <Entity.ItemMaster>();
foreach (var data in masterRepository.GetItemMasterList())
{
Entity.ItemMaster obj = new Entity.ItemMaster();
obj.ItemId = data.ItemId;
obj.ImagesPath = data.ImagesPath;
obj.Active = data.Active;
obj.CreatedBy = data.CreatedBy;
obj.CreatedDate = data.CreatedDate;
obj.ItemType = data.ItemType;
obj.Name = data.Name;
obj.Rate = data.Rate;
objList.Add(obj);
}
return(objList);
}
catch (Exception ex)
{
return(new List <Entity.ItemMaster>());
}
}
public bool AddNewItem(PharmaBusinessObjects.Master.ItemMaster newItem)
{
try
{
using (PharmaDBEntities context = new PharmaDBEntities())
{
using (var transaction = context.Database.BeginTransaction())
{
try
{
int _result = 0;
int totalItemsFromSameCompany = context.ItemMaster.Where(p => p.CompanyID == newItem.CompanyID).Count();
totalItemsFromSameCompany++;
//Add HSN if does not exist
if (!context.HSNCode.Where(x => x.HSNCode1 == newItem.HSNCode).Any())
{
Entity.HSNCode HSNCodeDBEntry = new HSNCode()
{
HSNCode1 = newItem.HSNCode,
HSNDescription = newItem.HSNCode + "- Default Description",
CreatedBy = this.LoggedInUser.Username,
CreatedOn = System.DateTime.Now
};
context.HSNCode.Add(HSNCodeDBEntry);
}
string companyCode = context.CompanyMaster.Where(p => p.CompanyId == newItem.CompanyID).FirstOrDefault().CompanyCode;
Entity.ItemMaster newItemMasterDB = new Entity.ItemMaster();
newItemMasterDB.ItemCode = string.Concat(companyCode, totalItemsFromSameCompany.ToString().PadLeft((9 - companyCode.Length), '0'));
newItemMasterDB.ItemName = newItem.ItemName;
newItemMasterDB.CompanyID = newItem.CompanyID;
newItemMasterDB.ConversionRate = newItem.ConversionRate;
newItemMasterDB.ShortName = newItem.ShortName;
newItemMasterDB.Packing = newItem.Packing;
newItemMasterDB.PurchaseRate = newItem.PurchaseRate;
newItemMasterDB.MRP = newItem.MRP;
newItemMasterDB.SaleRate = newItem.SaleRate;
newItemMasterDB.SpecialRate = newItem.SpecialRate;
newItemMasterDB.WholeSaleRate = newItem.WholeSaleRate;
newItemMasterDB.SaleExcise = newItem.SaleExcise;
newItemMasterDB.SurchargeOnSale = newItem.SurchargeOnSale;
newItemMasterDB.TaxOnSale = newItem.TaxOnSale;
newItemMasterDB.Scheme1 = newItem.Scheme1;
newItemMasterDB.Scheme2 = newItem.Scheme2;
newItemMasterDB.PurchaseExcise = newItem.PurchaseExcise;
newItemMasterDB.UPC = newItem.UPC;
newItemMasterDB.IsHalfScheme = newItem.IsHalfScheme;
newItemMasterDB.IsQTRScheme = newItem.IsQTRScheme;
newItemMasterDB.SpecialDiscount = newItem.SpecialDiscount;
newItemMasterDB.SpecialDiscountOnQty = newItem.SpecialDiscountOnQty;
newItemMasterDB.IsFixedDiscount = newItem.IsFixedDiscount;
newItemMasterDB.FixedDiscountRate = newItem.FixedDiscountRate;
newItemMasterDB.SurchargeOnPurchase = newItem.SurchargeOnPurchase;
newItemMasterDB.TaxOnPurchase = newItem.TaxOnPurchase;
newItemMasterDB.DiscountRecieved = newItem.DiscountRecieved;
newItemMasterDB.SpecialDiscountRecieved = newItem.SpecialDiscountRecieved;
newItemMasterDB.QtyPerCase = newItem.QtyPerCase;
newItemMasterDB.Location = newItem.Location;
newItemMasterDB.SaleTypeId = newItem.SaleTypeId;
newItemMasterDB.PurchaseTypeId = newItem.PurchaseTypeId;
newItemMasterDB.HSNCode = newItem.HSNCode;
newItemMasterDB.Status = newItem.Status;
newItemMasterDB.CreatedBy = this.LoggedInUser.Username;
newItemMasterDB.CreatedOn = System.DateTime.Now;
context.ItemMaster.Add(newItemMasterDB);
_result = context.SaveChanges();
transaction.Commit();
if (_result > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (DbEntityValidationException ex)
{
transaction.Rollback();
throw ex;
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public bool UpdateItem(PharmaBusinessObjects.Master.ItemMaster existingItem)
{
using (PharmaDBEntities context = new PharmaDBEntities())
{
using (var transaction = context.Database.BeginTransaction())
{
try
{
int _result = 0;
Entity.ItemMaster existingItemDB = context.ItemMaster.Where(p => p.ItemCode == existingItem.ItemCode && p.Status).FirstOrDefault();
//Add HSN if does not exist
if (!context.HSNCode.Where(x => x.HSNCode1 == existingItem.HSNCode).Any())
{
Entity.HSNCode HSNCodeDBEntry = new HSNCode()
{
HSNCode1 = existingItem.HSNCode,
HSNDescription = existingItem.HSNCode + "- Default Description",
CreatedBy = this.LoggedInUser.Username,
CreatedOn = System.DateTime.Now
};
context.HSNCode.Add(HSNCodeDBEntry);
}
if (existingItemDB != null)
{
existingItemDB.ItemName = existingItem.ItemName;
existingItemDB.CompanyID = existingItem.CompanyID;
existingItemDB.ConversionRate = existingItem.ConversionRate;
existingItemDB.ShortName = existingItem.ShortName;
existingItemDB.Packing = existingItem.Packing;
existingItemDB.PurchaseRate = existingItem.PurchaseRate;
existingItemDB.MRP = existingItem.MRP;
existingItemDB.SaleRate = existingItem.SaleRate;
existingItemDB.SpecialRate = existingItem.SpecialRate;
existingItemDB.WholeSaleRate = existingItem.WholeSaleRate;
existingItemDB.SaleExcise = existingItem.SaleExcise;
existingItemDB.SurchargeOnSale = existingItem.SurchargeOnSale;
existingItemDB.TaxOnSale = existingItem.TaxOnSale;
existingItemDB.Scheme1 = existingItem.Scheme1;
existingItemDB.Scheme2 = existingItem.Scheme2;
existingItemDB.PurchaseExcise = existingItem.PurchaseExcise;
existingItemDB.UPC = existingItem.UPC;
existingItemDB.IsHalfScheme = existingItem.IsHalfScheme;
existingItemDB.IsQTRScheme = existingItem.IsQTRScheme;
existingItemDB.SpecialDiscount = existingItem.SpecialDiscount;
existingItemDB.SpecialDiscountOnQty = existingItem.SpecialDiscountOnQty;
existingItemDB.IsFixedDiscount = existingItem.IsFixedDiscount;
existingItemDB.FixedDiscountRate = existingItem.FixedDiscountRate;
existingItemDB.SurchargeOnPurchase = existingItem.SurchargeOnPurchase;
existingItemDB.TaxOnPurchase = existingItem.TaxOnPurchase;
existingItemDB.DiscountRecieved = existingItem.DiscountRecieved;
existingItemDB.SpecialDiscountRecieved = existingItem.SpecialDiscountRecieved;
existingItemDB.QtyPerCase = existingItem.QtyPerCase;
existingItemDB.Location = existingItem.Location;
existingItemDB.SaleTypeId = existingItem.SaleTypeId;
existingItemDB.PurchaseTypeId = existingItem.PurchaseTypeId;
existingItemDB.HSNCode = existingItem.HSNCode;
existingItemDB.Status = existingItem.Status;
existingItemDB.ModifiedBy = this.LoggedInUser.Username;
existingItemDB.ModifiedOn = System.DateTime.Now;
}
_result = context.SaveChanges();
transaction.Commit();
_result = 1;
if (_result > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
transaction.Rollback();
return(false);
}
}
}
}
