public string UPdateItem(BE_ItemDef NewBEUpdateObj)
{
string a = string.Empty;
SqlConnection sqlconn = new SqlConnection(ConnString);
SqlCommand sqlcomm = new SqlCommand("UpdateItem", sqlconn);
sqlcomm.CommandType = CommandType.StoredProcedure;
sqlcomm.Parameters.AddWithValue("@ItemID", NewBEUpdateObj.ItemID);
sqlcomm.Parameters.AddWithValue("@ItemName", NewBEUpdateObj.ItemName);
sqlcomm.Parameters.AddWithValue("@GroupID", NewBEUpdateObj.GroupID);
sqlcomm.Parameters.AddWithValue("@MunitID", NewBEUpdateObj.MUnitID);
sqlcomm.Parameters.AddWithValue("@ItemPrice", NewBEUpdateObj.ItemPrice);
//sqlcomm.Parameters.AddWithValue("@IsActive", NewBEUpdateObj.IsActive);
try
{
sqlconn.Open();
sqlcomm.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, DataAccess.ProjectName, MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
finally
{
sqlconn.Close();
sqlcomm.Dispose();
}
return(a);
}
public DataTable GetItemName(BE_ItemDef GetItemName)
{
SqlConnection sqlconn = new SqlConnection(ConnString);
SqlCommand sqlcomm = new SqlCommand("GetItemname", sqlconn);
sqlcomm.CommandType = CommandType.StoredProcedure;
sqlcomm.Parameters.AddWithValue("@ItemID", GetItemName.ItemID);
DataTable dt = new DataTable();
dt = DataAccess.GetDataTable(sqlcomm, sqlconn);
try
{
sqlconn.Open();
sqlcomm.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, DataAccess.ProjectName, MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
finally
{
sqlconn.Close();
sqlcomm.Dispose();
}
return(dt);
}
public bool DuplicateItemName(BE_ItemDef NewUPdateItem)
{
SqlConnection sqlconn = new SqlConnection(ConnString);
string qry = "Select ItemID From Items Where ItemName like '%" + NewUPdateItem.ItemName + "%'";
DataTable dt = new DataTable();
dt = DataAccess.GetDataTable(qry, sqlconn);
if (dt.Rows.Count > 0)
{
return(true);
}
return(false);
}
public string UPdateItem(BE_ItemDef NewBEObj)
{
DAL_ItemDef NewDALObj = new DAL_ItemDef();
return(NewDALObj.UPdateItem(NewBEObj));
}
public DataTable GetItemName(BE_ItemDef NewBEObj)
{
DAL_ItemDef NewDALObj = new DAL_ItemDef();
return(NewDALObj.GetItemName(NewBEObj));
}
public bool DuplicateItemName(BE_ItemDef NewBEObj)
{
DAL_ItemDef NewDalObj = new DAL_ItemDef();
return(NewDalObj.DuplicateItemName(NewBEObj));
}
public string InsertItem(BE_ItemDef NewBEObj)
{
DAL_ItemDef NewDalObj = new DAL_ItemDef();
return(NewDalObj.InsertItem(NewBEObj));
}
