//update
public bool UpdateUM(eSunSpeedDomain.UnitMasterModel objUM)
{
string Query = string.Empty;
bool isUpdated = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@UnitName", objUM.UnitName));
paramCollection.Add(new DBParameter("@PrintName", objUM.PrintName));
paramCollection.Add(new DBParameter("@ExciseReturn", objUM.ExciseReturn));
paramCollection.Add(new DBParameter("@ModifiedBy", objUM.ModifiedBy));
paramCollection.Add(new DBParameter("@ModifiedBy", DateTime.Now));
paramCollection.Add(new DBParameter("@UM_ID", objUM.UM_ID));
Query = "UPDATE UnitMaster SET [UnitName]=@UnitName,[PrintName]=@PrintName,[ExciseReturn]=@ExciseReturn,[ModifiedBy]=@ModifiedBy,[ModifiedDate]=@ModifiedDate " +
"WHERE UM_Id=@UM_Id";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
isUpdated = true;
}
}
catch (Exception ex)
{
isUpdated = false;
throw ex;
}
return(isUpdated);
}
public bool SaveUM(eSunSpeedDomain.UnitMasterModel objUM)
{
string Query = string.Empty;
bool isSaved = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@UnitName", objUM.UnitName));
paramCollection.Add(new DBParameter("@PrintName", objUM.PrintName));
paramCollection.Add(new DBParameter("@UnitNameforexciseEreturn", objUM.ExciseReturn));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
Query = "INSERT INTO UnitMaster(`UnitName`,`PrintName`,`ExciseReturn`,`CreatedBy`) " +
"VALUES(@UnitName,@PrintName,@UnitNameforexciseEreturn,@CreatedBy)";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
isSaved = true;
}
}
catch (Exception ex)
{
isSaved = false;
throw ex;
}
return(isSaved);
}
