public string UPdateMUnit(BE_MUnit NewBEUpdateObj)
{
string a = string.Empty;
SqlConnection sqlconn = new SqlConnection(ConnString);
SqlCommand sqlcomm = new SqlCommand("UpdateMUnitName", sqlconn);
sqlcomm.CommandType = CommandType.StoredProcedure;
sqlcomm.Parameters.AddWithValue("@MUnitID", NewBEUpdateObj.MUnitID);
sqlcomm.Parameters.AddWithValue("@MUnitName", NewBEUpdateObj.MUnitName);
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 GetMUnitName(BE_MUnit MUnitName)
{
SqlConnection sqlconn = new SqlConnection(ConnString);
SqlCommand sqlcomm = new SqlCommand("GetMUnitName", sqlconn);
sqlcomm.CommandType = CommandType.StoredProcedure;
sqlcomm.Parameters.AddWithValue("@MUnitID", MUnitName.MUnitID);
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 string InsertMUnit(BE_MUnit NewMUnitInsertObj)
{
string a = string.Empty;
SqlConnection sqlconn = new SqlConnection(ConnString);
SqlCommand sqlcomm = new SqlCommand("InsertMUnit", sqlconn);
sqlcomm.CommandType = CommandType.StoredProcedure;
this.InvestmentPosting = int.Parse(DataAccess.GetMaxNO("MUnitID", "MUnit").ToString());
NewMUnitInsertObj.MUnitID = this.InvestmentPosting;
sqlcomm.Parameters.AddWithValue("@MUnitID", NewMUnitInsertObj.MUnitID);
sqlcomm.Parameters.AddWithValue("@MUnitName", NewMUnitInsertObj.MUnitName);
sqlcomm.Parameters.AddWithValue("@IsActive", NewMUnitInsertObj.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 bool DuplicateMUnit(BE_MUnit NewObjMUnit)
{
SqlConnection sqlconn = new SqlConnection(ConnString);
string qry = "Select MUnitID From MUnit Where MUnitName like '%" + NewObjMUnit.MUnitName + "%'";
DataTable dt = new DataTable();
dt = DataAccess.GetDataTable(qry, sqlconn);
if (dt.Rows.Count > 0)
{
return(true);
}
return(false);
}
public string UPdateMUnit(BE_MUnit NewBEUpdateObj)
{
DAL_MUnit NewDALObj = new DAL_MUnit();
return(NewDALObj.UPdateMUnit(NewBEUpdateObj));
}
public DataTable GetMUnitName(BE_MUnit NewBEObj)
{
DAL_MUnit NewDALObj = new DAL_MUnit();
return(NewDALObj.GetMUnitName(NewBEObj));
}
public bool DuplicateMUnit(BE_MUnit NewObjMunit)
{
DAL_MUnit NewDalObj = new DAL_MUnit();
return(NewDalObj.DuplicateMUnit(NewObjMunit));
}
public string InsertMUnit(BE_MUnit NewObjMUnit)
{
DAL_MUnit NewDALObj = new DAL_MUnit();
return(NewDALObj.InsertMUnit(NewObjMUnit));
}
