public void InsertRecord(Objects.StockIssue obj)
{
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_StockIssueInsert";
/**/
cmd.Parameters.AddWithValue("@IssueID", obj.IssueID);
cmd.Parameters.AddWithValue("@IssueDate", obj.IssueDate);
cmd.Parameters.AddWithValue("@SalesmanID", obj.SalesmanID);
cmd.Parameters.AddWithValue("@IsUploaded", obj.IsUploaded);
cmd.Parameters.AddWithValue("@BookerID", obj.BookerID);
cmd.Parameters.AddWithValue("@DeliveryDate", obj.DeliveryDate);
cmd.Parameters.AddWithValue("@OfficeID", obj.OfficeID);
new Database(connectionstring).ExecuteNonQueryOnly(cmd);
}
catch (Exception exc)
{
throw exc;
}
}
public void InsertRecordBody(Objects.StockIssueBody obj)
{
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_StockIssueBodyInsert";
/**/
cmd.Parameters.AddWithValue("@IssueID", obj.IssueID);
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("@PerUnitCostLose", obj.PerUnitCostLose);
cmd.Parameters.AddWithValue("@TTLValue", obj.TTLValue);
new Database(connectionstring).ExecuteNonQueryOnly(cmd);
}
catch (Exception exc)
{
throw exc;
}
}
public void UpdateRecord(Objects.StockIssue obj)
{
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_StockIssueUpdate";
cmd.Parameters.AddWithValue("@IssueID", obj.IssueID);
cmd.Parameters.AddWithValue("@IssueDate", obj.IssueDate);
cmd.Parameters.AddWithValue("@SalesmanID", obj.SalesmanID);
cmd.Parameters.AddWithValue("@IsUploaded", obj.IsUploaded);
cmd.Parameters.AddWithValue("@BookerID", obj.BookerID);
cmd.Parameters.AddWithValue("@DeliveryDate", obj.DeliveryDate);
cmd.Parameters.AddWithValue("@OfficeID", obj.OfficeID);
new Database(connectionstring).ExecuteNonQueryOnly(cmd);
}
catch (Exception exc)
{
throw exc;
}
}