private static string UpdateSales_Tax(Sales_Tax _Sales_Tax) { DbCommand command = Catalog_Access.CreateCommand(); //Have to wite the stored procedure command.CommandText = "sp_update_Sales_Tax"; DbParameter param; #region param = command.CreateParameter(); param.ParameterName = "@ID"; param.Value = _Sales_Tax.ID; param.DbType = DbType.Int32; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@Custom_Invoice_ID"; param.Value = _Sales_Tax.Custom_Invoice_ID; param.DbType = DbType.Int32; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@SerialNo"; param.Value = _Sales_Tax.SerialNo; param.DbType = DbType.String; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@Date"; param.Value = _Sales_Tax.Date; param.DbType = DbType.DateTime; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@PaymentTerm"; param.Value = _Sales_Tax.PaymentTerm; param.DbType = DbType.String; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@SupplierId"; param.Value = _Sales_Tax.SupplierId; param.DbType = DbType.Int32; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@Buyer"; param.Value = _Sales_Tax.Buyer; param.DbType = DbType.String; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@Address"; param.Value = _Sales_Tax.Address; param.DbType = DbType.String; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@StReg"; param.Value = _Sales_Tax.StReg; param.DbType = DbType.String; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@UpdatedBy"; param.Value = _Sales_Tax.UpdatedBy; param.DbType = DbType.String; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@Return"; param.DbType = DbType.Int32; param.Direction = ParameterDirection.Output; command.Parameters.Add(param); #endregion Catalog_Access.ExecuteNonQuery(command); string Return = command.Parameters["@Return"].Value.ToString(); return Return; }
// update public static string Update(Sales_Tax _Sales_Tax, List<Sales_Tax_B> _Sales_Tax_B) { if (UpdateSales_Tax(_Sales_Tax) == "4") { UpdateCollection(_Sales_Tax_B, _Sales_Tax.ID, _Sales_Tax.UpdatedBy); return "4"; } else { return "1"; } }
public Sales_Tax Get(int ID) { // Customer Detail Sales_Tax _Sales_Tax = new Sales_Tax(); DataTable dt = Sales_Tax_DA.Get(ID); //_Sales_Tax.Customer_ID = int.Parse(dt.Rows[0]["Customer_ID"].ToString()); _Sales_Tax.Custom_Invoice_ID = int.Parse(dt.Rows[0]["Custom_Invoice_ID"].ToString()); _Sales_Tax.SerialNo = dt.Rows[0]["SerialNo"].ToString(); _Sales_Tax.SupplierId = int.Parse(dt.Rows[0]["SupplierId"].ToString()); _Sales_Tax.DateString = Convert.ToDateTime(dt.Rows[0]["Date"].ToString()).ToString("MM/dd/yyyy"); _Sales_Tax.PaymentTerm = dt.Rows[0]["PaymentTerm"].ToString(); _Sales_Tax.Buyer = dt.Rows[0]["Buyer"].ToString(); _Sales_Tax.Address = dt.Rows[0]["Address"].ToString(); _Sales_Tax.StReg = dt.Rows[0]["StReg"].ToString(); return _Sales_Tax; }
//insert public static string Insert(Sales_Tax _Sales_Tax, List<Sales_Tax_B> _Sales_Tax_B) { int ID = InsertSales_Tax(_Sales_Tax); if (ID > 0) { InsertPackingWeightCollection(_Sales_Tax_B, ID, _Sales_Tax.CreatedBy); return "0"; } else { return "1"; } }
public string Submit(Sales_Tax _Sales_Tax, List<Sales_Tax_B> _Sales_Tax_B) { string msg = ""; if (_Sales_Tax.ID == null) { _Sales_Tax.CreatedBy = Session["User"].ToString(); msg = Sales_Tax_DA.Insert(_Sales_Tax, _Sales_Tax_B); } else { _Sales_Tax.UpdatedBy = Session["User"].ToString(); msg = Sales_Tax_DA.Update(_Sales_Tax, _Sales_Tax_B); } return msg; }