public bool AddMItemMaster(MItemMaster mItemMaster)
{
SqlCommand cmd;
cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "AddMItemMaster";
cmd.Parameters.AddWithValue("@ItemNo", mItemMaster.ItemNo);
cmd.Parameters.AddWithValue("@ItemName", mItemMaster.ItemName);
cmd.Parameters.AddWithValue("@ItemShortName", mItemMaster.ItemShortName);
cmd.Parameters.AddWithValue("@Barcode", mItemMaster.Barcode);
cmd.Parameters.AddWithValue("@ShortCode", mItemMaster.ShortCode);
cmd.Parameters.AddWithValue("@GroupNo", mItemMaster.GroupNo);
cmd.Parameters.AddWithValue("@UOML", mItemMaster.UOML);
cmd.Parameters.AddWithValue("@UOMH", mItemMaster.UOMH);
cmd.Parameters.AddWithValue("@UOMDefault", mItemMaster.UOMDefault);
cmd.Parameters.AddWithValue("@FkDepartmentNo", mItemMaster.FkDepartmentNo);
cmd.Parameters.AddWithValue("@FkCategoryNo", mItemMaster.FkCategoryNo);
cmd.Parameters.AddWithValue("@MinLevel", mItemMaster.MinLevel);
cmd.Parameters.AddWithValue("@MaxLevel", mItemMaster.MaxLevel);
cmd.Parameters.AddWithValue("@LangFullDesc", mItemMaster.LangFullDesc);
cmd.Parameters.AddWithValue("@LangShortDesc", mItemMaster.LangShortDesc);
cmd.Parameters.AddWithValue("@CompanyNo", mItemMaster.CompanyNo);
cmd.Parameters.AddWithValue("@IsActive", mItemMaster.IsActive);
cmd.Parameters.AddWithValue("@UserId", mItemMaster.UserId);
cmd.Parameters.AddWithValue("@UserDate", mItemMaster.UserDate);
cmd.Parameters.AddWithValue("@ControlUnder", mItemMaster.ControlUnder);
cmd.Parameters.AddWithValue("@FactorVal", mItemMaster.FactorVal);
cmd.Parameters.AddWithValue("@Margin", mItemMaster.Margin);
cmd.Parameters.AddWithValue("@CessValue", mItemMaster.CessValue);
cmd.Parameters.AddWithValue("@PackagingCharges", mItemMaster.PackagingCharges);
cmd.Parameters.AddWithValue("@Dhekhrek", mItemMaster.Dhekhrek);
cmd.Parameters.AddWithValue("@OtherCharges", mItemMaster.OtherCharges);
cmd.Parameters.AddWithValue("@HigherVariation", mItemMaster.HigherVariation);
cmd.Parameters.AddWithValue("@LowerVariation", mItemMaster.LowerVariation);
//---GST------//
cmd.Parameters.AddWithValue("@HSNCode", mItemMaster.HSNCode);
cmd.Parameters.AddWithValue("@FKStockGroupTypeNo", mItemMaster.FKStockGroupTypeNo);
cmd.Parameters.AddWithValue("@ItemType", mItemMaster.ItemType);
cmd.Parameters.AddWithValue("@ESFlag", mItemMaster.ESFlag);
cmd.Parameters.AddWithValue("@ContainerCharges", mItemMaster.ContainerCharges);
cmd.Parameters.AddWithValue("@GSTSlab", mItemMaster.GSTSlab);
SqlParameter outParameter = new SqlParameter();
outParameter.ParameterName = "@ReturnID";
outParameter.Direction = ParameterDirection.Output;
outParameter.DbType = DbType.Int32;
cmd.Parameters.Add(outParameter);
commandcollection.Add(cmd);
return(true);
}
public bool UpdateMItemMasterIsActive(MItemMaster mItemMaster)
{
SqlCommand cmd;
cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "Update mItemMaster set mItemMaster.IsActive=@IsActive,StatusNo=2 where mItemMaster.ItemNo=@ItemNo";
cmd.Parameters.AddWithValue("@ItemNo", mItemMaster.ItemNo);
cmd.Parameters.AddWithValue("@IsActive", mItemMaster.IsActive);
commandcollection.Add(cmd);
return(true);
}
public bool DeleteMItemMaster(MItemMaster mItemMaster)
{
SqlCommand cmd;
cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "DeleteMItemMaster";
cmd.Parameters.AddWithValue("@ItemNo", mItemMaster.ItemNo);
if (ObjTrans.ExecuteNonQuery(cmd, CommonFunctions.ConStr) == true)
{
return(true);
}
else
{
mItemMaster.msg = ObjTrans.ErrorMessage;
return(false);
}
}
public MItemMaster ModifyMItemMasterByID(long ID)
{
SqlConnection Con = new SqlConnection(CommonFunctions.ConStr);
string sql;
SqlCommand cmd;
sql = "Select * from MItemMaster where ItemNo =" + ID;
cmd = new SqlCommand(sql, Con);
cmd.Connection = Con;
Con.Open();
cmd.CommandType = CommandType.Text;
SqlDataReader dr;
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
if (dr.HasRows)
{
MItemMaster MM = new MItemMaster();
while (dr.Read())
{
MM.ItemNo = Convert.ToInt32(dr["ItemNo"]);
if (!Convert.IsDBNull(dr["ItemName"]))
{
MM.ItemName = Convert.ToString(dr["ItemName"]);
}
if (!Convert.IsDBNull(dr["ItemShortName"]))
{
MM.ItemShortName = Convert.ToString(dr["ItemShortName"]);
}
if (!Convert.IsDBNull(dr["Barcode"]))
{
MM.Barcode = Convert.ToString(dr["Barcode"]);
}
if (!Convert.IsDBNull(dr["ShortCode"]))
{
MM.ShortCode = Convert.ToString(dr["ShortCode"]);
}
if (!Convert.IsDBNull(dr["GroupNo"]))
{
MM.GroupNo = Convert.ToInt64(dr["GroupNo"]);
}
if (!Convert.IsDBNull(dr["UOMH"]))
{
MM.UOMH = Convert.ToInt64(dr["UOMH"]);
}
if (!Convert.IsDBNull(dr["UOML"]))
{
MM.UOML = Convert.ToInt64(dr["UOML"]);
}
if (!Convert.IsDBNull(dr["UOMDefault"]))
{
MM.UOMDefault = Convert.ToInt64(dr["UOMDefault"]);
}
if (!Convert.IsDBNull(dr["FkDepartmentNo"]))
{
MM.FkDepartmentNo = Convert.ToInt64(dr["FkDepartmentNo"]);
}
if (!Convert.IsDBNull(dr["FkCategoryNo"]))
{
MM.FkCategoryNo = Convert.ToInt64(dr["FkCategoryNo"]);
}
if (!Convert.IsDBNull(dr["MinLevel"]))
{
MM.MinLevel = Convert.ToInt64(dr["MinLevel"]);
}
if (!Convert.IsDBNull(dr["MaxLevel"]))
{
MM.MaxLevel = Convert.ToInt64(dr["MaxLevel"]);
}
if (!Convert.IsDBNull(dr["ReOrderLevelQty"]))
{
MM.ReOrderLevelQty = Convert.ToInt64(dr["ReOrderLevelQty"]);
}
if (!Convert.IsDBNull(dr["LangFullDesc"]))
{
MM.LangFullDesc = Convert.ToString(dr["LangFullDesc"]);
}
if (!Convert.IsDBNull(dr["LangShortDesc"]))
{
MM.LangShortDesc = Convert.ToString(dr["LangShortDesc"]);
}
if (!Convert.IsDBNull(dr["CompanyNo"]))
{
MM.CompanyNo = Convert.ToInt64(dr["CompanyNo"]);
}
if (!Convert.IsDBNull(dr["IsActive"]))
{
MM.IsActive = Convert.ToBoolean(dr["IsActive"]);
}
if (!Convert.IsDBNull(dr["UserId"]))
{
MM.UserId = Convert.ToInt64(dr["UserId"]);
}
if (!Convert.IsDBNull(dr["UserDate"]))
{
MM.UserDate = Convert.ToDateTime(dr["UserDate"]);
}
if (!Convert.IsDBNull(dr["ModifiedBy"]))
{
MM.ModifiedBy = Convert.ToString(dr["ModifiedBy"]);
}
if (!Convert.IsDBNull(dr["StatusNo"]))
{
MM.StatusNo = Convert.ToInt32(dr["StatusNo"]);
}
if (!Convert.IsDBNull(dr["ControlUnder"]))
{
MM.ControlUnder = Convert.ToInt64(dr["ControlUnder"]);
}
if (!Convert.IsDBNull(dr["FactorVal"]))
{
MM.FactorVal = Convert.ToInt64(dr["FactorVal"]);
}
if (!Convert.IsDBNull(dr["Margin"]))
{
MM.Margin = Convert.ToInt64(dr["Margin"]);
}
if (!Convert.IsDBNull(dr["CessValue"]))
{
MM.CessValue = Convert.ToDouble(dr["CessValue"]);
}
if (!Convert.IsDBNull(dr["PackagingCharges"]))
{
MM.PackagingCharges = Convert.ToDouble(dr["PackagingCharges"]);
}
if (!Convert.IsDBNull(dr["Dhekhrek"]))
{
MM.Dhekhrek = Convert.ToDouble(dr["Dhekhrek"]);
}
if (!Convert.IsDBNull(dr["OtherCharges"]))
{
MM.OtherCharges = Convert.ToDouble(dr["OtherCharges"]);
}
if (!Convert.IsDBNull(dr["HigherVariation"]))
{
MM.HigherVariation = Convert.ToInt64(dr["HigherVariation"]);
}
if (!Convert.IsDBNull(dr["LowerVariation"]))
{
MM.LowerVariation = Convert.ToInt64(dr["LowerVariation"]);
}
if (!Convert.IsDBNull(dr["HSNCode"]))
{
MM.HSNCode = Convert.ToString(dr["HSNCode"]);
}
if (!Convert.IsDBNull(dr["ItemType"]))
{
MM.ItemType = Convert.ToInt32(dr["ItemType"]);
}
if (!Convert.IsDBNull(dr["ESFlag"]))
{
MM.ESFlag = Convert.ToBoolean(dr["ESFlag"]);
}
if (!Convert.IsDBNull(dr["ContainerCharges"]))
{
MM.ContainerCharges = Convert.ToDouble(dr["ContainerCharges"]);
}
if (!Convert.IsDBNull(dr["GSTSlab"]))
{
MM.GSTSlab = Convert.ToBoolean(dr["GSTSlab"]);
}
}
dr.Close();
return(MM);
}
else
{
dr.Close();
}
return(new MItemMaster());
}
