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()); }