public bool AddMRateSetting2(MRateSetting mratesetting)
{
SqlCommand cmd;
cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "AddMRateSetting2";
cmd.Parameters.AddWithValue("@PkSrNo", mratesetting.PkSrNo);
//cmd.Parameters.AddWithValue("@FkBcdSrNo", mratesetting.FkBcdSrNo);
// cmd.Parameters.AddWithValue("@ItemNo", mratesetting.ItemNo);
cmd.Parameters.AddWithValue("@FromDate", mratesetting.FromDate);
cmd.Parameters.AddWithValue("@PurRate", mratesetting.PurRate);
cmd.Parameters.AddWithValue("@MRP", mratesetting.MRP);
cmd.Parameters.AddWithValue("@UOMNo", mratesetting.UOMNo);
cmd.Parameters.AddWithValue("@ASaleRate", mratesetting.ASaleRate);
cmd.Parameters.AddWithValue("@BSaleRate", mratesetting.BSaleRate);
cmd.Parameters.AddWithValue("@CSaleRate", mratesetting.CSaleRate);
cmd.Parameters.AddWithValue("@DSaleRate", mratesetting.DSaleRate);
cmd.Parameters.AddWithValue("@ESaleRate", mratesetting.ESaleRate);
cmd.Parameters.AddWithValue("@StockConversion", mratesetting.StockConversion);
// cmd.Parameters.AddWithValue("@PerOfRateVariation", mratesetting.PerOfRateVariation);
cmd.Parameters.AddWithValue("@MKTQty", mratesetting.MKTQty);
cmd.Parameters.AddWithValue("@IsActive", mratesetting.IsActive);
cmd.Parameters.AddWithValue("@UserID", mratesetting.UserID);
cmd.Parameters.AddWithValue("@UserDate", mratesetting.UserDate);
cmd.Parameters.AddWithValue("@CompanyNo", mratesetting.CompanyNo);
cmd.Parameters.AddWithValue("@Weight1", mratesetting.Weight1);
cmd.Parameters.AddWithValue("@Weight2", mratesetting.Weight2);
cmd.Parameters.AddWithValue("@LPPerc", mratesetting.LPPerc);
cmd.Parameters.AddWithValue("@SPPerc", mratesetting.SPPerc);
cmd.Parameters.AddWithValue("@Hamali", mratesetting.Hamali);
commandcollection.Add(cmd);
return(true);
}
public bool AddMRateSetting1(MRateSetting mratesetting)
{
SqlCommand cmd;
cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "AddMRateSetting";
cmd.Parameters.AddWithValue("@PkSrNo", mratesetting.PkSrNo);
// cmd.Parameters.AddWithValue("@FkBcdSrNo", mratesetting.FkBcdSrNo);
cmd.Parameters.AddWithValue("@ItemNo", mratesetting.ItemNo);
cmd.Parameters.AddWithValue("@FromDate", mratesetting.FromDate);
cmd.Parameters.AddWithValue("@PurRate", mratesetting.PurRate);
cmd.Parameters.AddWithValue("@MRP", mratesetting.MRP);
cmd.Parameters.AddWithValue("@UOMNo", mratesetting.UOMNo);
cmd.Parameters.AddWithValue("@ASaleRate", mratesetting.ASaleRate);
cmd.Parameters.AddWithValue("@BSaleRate", mratesetting.BSaleRate);
cmd.Parameters.AddWithValue("@CSaleRate", mratesetting.CSaleRate);
cmd.Parameters.AddWithValue("@DSaleRate", mratesetting.DSaleRate);
cmd.Parameters.AddWithValue("@ESaleRate", mratesetting.ESaleRate);
cmd.Parameters.AddWithValue("@StockConversion", mratesetting.StockConversion);
cmd.Parameters.AddWithValue("@PerOfRateVariation", mratesetting.PerOfRateVariation);
cmd.Parameters.AddWithValue("@MKTQty", mratesetting.MKTQty);
cmd.Parameters.AddWithValue("@IsActive", mratesetting.IsActive);
cmd.Parameters.AddWithValue("@UserID", mratesetting.UserID);
cmd.Parameters.AddWithValue("@UserDate", mratesetting.UserDate);
cmd.Parameters.AddWithValue("@CompanyNo", mratesetting.CompanyNo);
// cmd.Parameters.AddWithValue("@CompanyNo", mratesetting.AreaNo);
if (ObjTrans.ExecuteNonQuery(cmd, CommonFunctions.ConStr) == true)
{
return(true);
}
else
{
mratesetting.msg = ObjTrans.ErrorMessage;
return(false);
}
}
public bool UpdateMRateSetting(MRateSetting mRateSetting)
{
SqlCommand cmd;
cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "Update MRateSetting set IsActive=@IsActive,StatusNo=2 where PkSrNo=@PksrNo; Update MStockItems set StatusNo=2 Where ItemNo=@ItemNo";
cmd.Parameters.AddWithValue("@PksrNo", mRateSetting.PkSrNo);
cmd.Parameters.AddWithValue("@IsActive", mRateSetting.IsActive);
cmd.Parameters.AddWithValue("@ItemNo", mRateSetting.ItemNo);
commandcollection.Add(cmd);
return(true);
}