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