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