public int Update(SaleQuotation saleQuotation) { UpdateCommand.Parameters["@ID"].Value = saleQuotation.ID; UpdateCommand.Parameters["@ReferenceNo"].Value = saleQuotation.ReferenceNo; UpdateCommand.Parameters["@InventoryItemID"].Value = saleQuotation.InventoryItemID; UpdateCommand.Parameters["@ItemName"].Value = saleQuotation.ItemName; UpdateCommand.Parameters["@Description"].Value = saleQuotation.Description; UpdateCommand.Parameters["@Price"].Value = saleQuotation.Price; UpdateCommand.Parameters["@Qty"].Value = saleQuotation.Qty; UpdateCommand.Parameters["@Amount"].Value = saleQuotation.Amount; UpdateCommand.Parameters["@Status"].Value = saleQuotation.Status; int returnValue = -1; try { UpdateCommand.Connection.Open(); returnValue = UpdateCommand.ExecuteNonQuery(); } catch (SqlException ex) { Logger.Write(ex); } finally { UpdateCommand.Connection.Close(); } return(returnValue); }
public int Insert(SaleQuotation saleQuotation) { InsertCommand.Parameters["@ReferenceNo"].Value = saleQuotation.ReferenceNo; InsertCommand.Parameters["@InventoryItemID"].Value = saleQuotation.InventoryItemID; InsertCommand.Parameters["@ItemName"].Value = saleQuotation.ItemName; InsertCommand.Parameters["@Description"].Value = saleQuotation.Description; InsertCommand.Parameters["@Price"].Value = saleQuotation.Price; InsertCommand.Parameters["@Qty"].Value = saleQuotation.Qty; InsertCommand.Parameters["@Amount"].Value = saleQuotation.Amount; InsertCommand.Parameters["@Status"].Value = saleQuotation.Status; int returnValue = -1; try { InsertCommand.Connection.Open(); returnValue = (int)InsertCommand.ExecuteScalar(); } catch (SqlException ex) { Logger.Write(ex); } finally { InsertCommand.Connection.Close(); } return(returnValue); }
private SaleQuotation DataTableToEntity(DataTable dt) { SaleQuotation saleQuotation = new SaleQuotation(); if (Null.IsNotNull(dt) == true && dt.Rows.Count > 0) { if (Null.IsNotNull(dt.Rows[0])) { DataRow dr = dt.Rows[0]; if (Null.IsNotNull(dr["ID"])) { saleQuotation.ID = Convert.ToInt32(dr["ID"]); } else { saleQuotation.ID = 0; } if (Null.IsNotNull(dr["ReferenceNo"])) { saleQuotation.ReferenceNo = Convert.ToString(dr["ReferenceNo"]); } else { saleQuotation.ReferenceNo = string.Empty; } if (Null.IsNotNull(dr["InventoryItemID"])) { saleQuotation.InventoryItemID = Convert.ToInt32(dr["InventoryItemID"]); } else { saleQuotation.InventoryItemID = 0; } if (Null.IsNotNull(dr["ItemName"])) { saleQuotation.ItemName = Convert.ToString(dr["ItemName"]); } else { saleQuotation.ItemName = string.Empty; } if (Null.IsNotNull(dr["Description"])) { saleQuotation.Description = Convert.ToString(dr["Description"]); } else { saleQuotation.Description = string.Empty; } if (Null.IsNotNull(dr["Price"])) { saleQuotation.Price = Convert.ToDecimal(dr["Price"]); } else { saleQuotation.Price = 0.00m; } if (Null.IsNotNull(dr["Qty"])) { saleQuotation.Qty = Convert.ToInt32(dr["Qty"]); } else { saleQuotation.Qty = 0; } if (Null.IsNotNull(dr["Amount"])) { saleQuotation.Amount = Convert.ToDecimal(dr["Amount"]); } else { saleQuotation.Amount = 0.00m; } if (Null.IsNotNull(dr["Status"])) { saleQuotation.Status = Convert.ToString(dr["Status"]); } else { saleQuotation.Status = string.Empty; } } } return(saleQuotation); }