public void InsertRecord(Objects.StockReturn obj)
{
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_StockReturnInsert";
/**/
cmd.Parameters.AddWithValue("@ReturnId", obj.ReturnId);
cmd.Parameters.AddWithValue("@Returndate", obj.Returndate);
cmd.Parameters.AddWithValue("@SalesmanID", obj.SalesmanID);
cmd.Parameters.AddWithValue("@IsUploaded", obj.IsUploaded);
cmd.Parameters.AddWithValue("@OfficeID", obj.OfficeID);
new Database(connectionstring).ExecuteNonQueryOnly(cmd);
}
catch (Exception exc)
{
throw exc;
}
}
public void InsertRecordBody(Objects.StockReturnBody obj)
{
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_StockReturnBodyInsert";
/**/
cmd.Parameters.AddWithValue("@ReturnID", obj.ReturnID);
cmd.Parameters.AddWithValue("@ProductID", obj.ProductID);
cmd.Parameters.AddWithValue("@PackingId", obj.PackingId);
cmd.Parameters.AddWithValue("@Multiplier", obj.Multiplier);
cmd.Parameters.AddWithValue("@QtyPack", obj.QtyPack);
cmd.Parameters.AddWithValue("@QtyLose", obj.QtyLose);
cmd.Parameters.AddWithValue("@TTLValue", obj.TTLValue);
cmd.Parameters.AddWithValue("@PerUnitCostLose", obj.PerUnitCostLose);
cmd.Parameters.AddWithValue("@DamageQty", obj.DamageQty);
new Database(connectionstring).ExecuteNonQueryOnly(cmd);
}
catch (Exception exc)
{
throw exc;
}
}
public void UpdateRecord(Objects.StockReturn obj)
{
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_StockReturnUpdate";
cmd.Parameters.AddWithValue("@ReturnId", obj.ReturnId);
cmd.Parameters.AddWithValue("@Returndate", obj.Returndate);
cmd.Parameters.AddWithValue("@SalesmanID", obj.SalesmanID);
cmd.Parameters.AddWithValue("@IsUploaded", obj.IsUploaded);
cmd.Parameters.AddWithValue("@OfficeID", obj.OfficeID);
new Database(connectionstring).ExecuteNonQueryOnly(cmd);
}
catch (Exception exc)
{
throw exc;
}
}
