public int AddProduct(tbl_ProductMaster objProductMaster)
{
try
{
isExist = 0;
dtRecords = new DataTable();
objSKSEntities = new SKSEntities();
isExist = (from ProductMaster in objSKSEntities.tbl_ProductMaster where (ProductMaster.FK_CompanyMasterID == objProductMaster.FK_CompanyMasterID && ProductMaster.ProductName == objProductMaster.ProductName && ProductMaster.IsDeleted == false) select ProductMaster.Id).SingleOrDefault();;
if (isExist > 0)
{
return(isExist);
}
else
{
objSKSEntities.tbl_ProductMaster.Add(objProductMaster);
objSKSEntities.SaveChanges();
return(isExist);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
dtRecords.Dispose();
}
}
public void DeleteorEnableDisableCompanyProduct(int ProductID, bool blnTrueFalse, bool blnDelete)
{
try
{
objSKSEntities = new SKSEntities();
objProductMaster = objSKSEntities.tbl_ProductMaster.SingleOrDefault(x => x.Id == ProductID); //returns a single item.
if (objProductMaster != null)
{
objProductMaster.IsActive = blnTrueFalse;
objProductMaster.IsDeleted = blnDelete;
objSKSEntities.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
objSKSEntities = null;
objProductMaster = null;
}
}
public static string AddProduct(int CompanyID, string ProductName, string HSNCode, string UOM, bool Status)
{
frmProductMaster objfrmProductMaster = new frmProductMaster();
try
{
objBusinessFacadLayer_Static = new BusinessFacadLayer();
if (CompanyID <= 0)
{
return("false|Select Company Name");
}
else if (ProductName.Trim() == "")
{
return("false|Enter Product Name");
}
else if (HSNCode.Trim() == "")
{
return("false|Enter HSN Code");
}
else if (UOM.Trim() == "")
{
return("false|Enter UOM");
}
objBusinessFacadLayer_Static = new BusinessFacadLayer();
objProductMaster_Static = new tbl_ProductMaster();
objProductMaster_Static.FK_CompanyMasterID = CompanyID;
objProductMaster_Static.ProductName = ProductName;
objProductMaster_Static.HSNCode = HSNCode;
objProductMaster_Static.UOM = UOM;
objProductMaster_Static.IsActive = Status;
objProductMaster_Static.IsDeleted = false;
objProductMaster_Static.CreatedBy = "Admin";
objProductMaster_Static.CreatedOn = Convert.ToDateTime(DateTime.Now.ToString());
isExist = objBusinessFacadLayer_Static.AddProduct(objProductMaster_Static);
if (isExist > 0)
{
return("failed|Product -" + ProductName + ", already exist for Company -");// + objfrmProductMaster.ddlCompanyName.SelectedItem.Text.ToString();
}
else
{
return("success|New Product -" + ProductName + ", added successfully");// + objfrmProductMaster.ddlCompanyName.SelectedItem.Text.ToString() + " - Company";
}
}
catch (Exception ex)
{
throw ex;
}
}
private void btnSubmit_Click(object sender, EventArgs e)
{
ppMessage = new PopupMessage();
try
{
if (txtpName.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtpName, "Enter Product Name.");
txtpName.Focus();
panel4.Visible = true;
lblError.Text = "Enter Product Name.";
}
else if (txtRate.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtRate, "Enter Rate.");
txtRate.Focus();
panel4.Visible = true;
lblError.Text = "Enter Rate.";
}
else
{
if (btnSubmit.Text == "Submit")
{
//Save No Code
_entities = new TSEntities();
tbl_ProductMaster pm = new tbl_ProductMaster();
pm.p_Name = txtpName.Text.Trim().ToString();
pm.rate = Convert.ToDecimal(txtRate.Text.Trim());
_entities.tbl_ProductMaster.Add(pm);
_entities.SaveChanges();
//Notification
ppMessage.successMessage();
}
else
{
// Update No Code
_entities = new TSEntities();
var data = _entities.tbl_ProductMaster.Where(x => x.id == ProductId).FirstOrDefault();
data.p_Name = txtpName.Text.Trim().ToString();
data.rate = Convert.ToDecimal(txtRate.Text.Trim());
_entities.SaveChanges();
ppMessage.updateMessage();
}
// Clear Function Call
clear();
}
}
catch (Exception x)
{
ppMessage.infoMessage("Something went wrong. Contact your system administrator!");
}
}
