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 PharmaBusinessObjects.Master.ItemMaster GetItemByCodeAndCustomer(int itemCode, string customerCode)
{
PharmaBusinessObjects.Master.ItemMaster master = new PharmaBusinessObjects.Master.ItemMaster();
using (PharmaDBEntities context = new PharmaDBEntities())
{
SqlConnection connection = (SqlConnection)context.Database.Connection;
SqlCommand cmd = new SqlCommand("GetSaleLineItemByCode", connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ItemCode", itemCode));
cmd.Parameters.Add(new SqlParameter("@CustomerCode", customerCode));
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
if (dt != null && dt.Rows.Count > 0)
{
master.ItemID = Convert.IsDBNull(dt.Rows[0]["ItemId"]) ? 0 : Convert.ToInt32(dt.Rows[0]["ItemId"]);
master.ItemCode = Convert.ToString(dt.Rows[0]["ItemCode"]);
master.ItemName = Convert.ToString(dt.Rows[0]["ItemName"]);
master.CompanyID = Convert.IsDBNull(dt.Rows[0]["CompanyID"]) ? 0 : Convert.ToInt32(dt.Rows[0]["CompanyID"]);
master.SaleRate = Convert.IsDBNull(dt.Rows[0]["SaleRate"]) ? 0 : Convert.ToDecimal(dt.Rows[0]["SaleRate"]);
master.SpecialRate = Convert.IsDBNull(dt.Rows[0]["SpecialRate"]) ? 0 : Convert.ToDecimal(dt.Rows[0]["SpecialRate"]);
master.WholeSaleRate = Convert.IsDBNull(dt.Rows[0]["WholeSaleRate"]) ? 0 : Convert.ToDecimal(dt.Rows[0]["WholeSaleRate"]);
master.SaleExcise = Convert.IsDBNull(dt.Rows[0]["SaleExcise"]) ? 0 : Convert.ToDecimal(dt.Rows[0]["SaleExcise"]);
master.SurchargeOnSale = Convert.IsDBNull(dt.Rows[0]["SurchargeOnSale"]) ? 0 : Convert.ToDecimal(dt.Rows[0]["SurchargeOnSale"]);
master.TaxOnSale = Convert.IsDBNull(dt.Rows[0]["TaxOnSale"]) ? 0 : Convert.ToDecimal(dt.Rows[0]["TaxOnSale"]);
master.Scheme1 = Convert.IsDBNull(dt.Rows[0]["Scheme1"]) ? 0 : Convert.ToDecimal(dt.Rows[0]["Scheme1"]);
master.Scheme2 = Convert.IsDBNull(dt.Rows[0]["Scheme2"]) ? 0 : Convert.ToDecimal(dt.Rows[0]["Scheme2"]);
master.IsHalfScheme = Convert.IsDBNull(dt.Rows[0]["IsHalfScheme"]) ? false : Convert.ToBoolean(dt.Rows[0]["IsHalfScheme"]);
master.IsQTRScheme = Convert.IsDBNull(dt.Rows[0]["IsQTRScheme"]) ? false : Convert.ToBoolean(dt.Rows[0]["IsQTRScheme"]);
master.SpecialDiscount = Convert.IsDBNull(dt.Rows[0]["SpecialDiscount"]) ? 0 : Convert.ToDecimal(dt.Rows[0]["SpecialDiscount"]);
master.SpecialDiscountOnQty = Convert.IsDBNull(dt.Rows[0]["SpecialDiscountOnQty"]) ? 0 : Convert.ToDecimal(dt.Rows[0]["SpecialDiscountOnQty"]);
master.IsFixedDiscount = Convert.IsDBNull(dt.Rows[0]["IsFixedDiscount"]) ? false : Convert.ToBoolean(dt.Rows[0]["IsFixedDiscount"]);
master.FixedDiscountRate = Convert.IsDBNull(dt.Rows[0]["FixedDiscountRate"]) ? 0 : Convert.ToDecimal(dt.Rows[0]["FixedDiscountRate"]);
master.QtyPerCase = Convert.IsDBNull(dt.Rows[0]["QtyPerCase"]) ? 0 : Convert.ToDecimal(dt.Rows[0]["QtyPerCase"]);
master.Location = Convert.ToString(dt.Rows[0]["Location"]);
master.SaleTypeId = Convert.IsDBNull(dt.Rows[0]["SaleTypeId"]) ? 0 : Convert.ToInt32(dt.Rows[0]["SaleTypeId"]);
//master.Discount = Convert.IsDBNull(dt.Rows[0]["Discount"]) ? 0 : Convert.ToDouble(dt.Rows[0]["Discount"]);
// master.Batch = Convert.ToString(dt.Rows[0]["Batch"]);
master.Packing = Convert.ToString(dt.Rows[0]["Packing"]);
master.PurchaseRate = Convert.IsDBNull(dt.Rows[0]["PurchaseRate"]) ? 0 : Convert.ToDecimal(dt.Rows[0]["PurchaseRate"]);
// master.FifoID = Convert.IsDBNull(dt.Rows[0]["FifoID"]) ? 0 : Convert.ToInt32(dt.Rows[0]["FifoID"]);
}
}
return(master);
}
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);
}
}
}
}
