public static INV_Sale GetSTD_CampusByCampusID(int CampusID) { INV_Sale iNV_Sale = new INV_Sale(); SqlINV_SaleProvider sqlINV_SaleProvider = new SqlINV_SaleProvider(); iNV_Sale = sqlINV_SaleProvider.GetINV_SaleByCampusID(CampusID); return iNV_Sale; }
public static INV_Sale GetINV_SaleBySaleID(int SaleID) { INV_Sale iNV_Sale = new INV_Sale(); SqlINV_SaleProvider sqlINV_SaleProvider = new SqlINV_SaleProvider(); iNV_Sale = sqlINV_SaleProvider.GetINV_SaleBySaleID(SaleID); return iNV_Sale; }
public static INV_Sale GetINV_IteamByIteamID(int IteamID) { INV_Sale iNV_Sale = new INV_Sale(); SqlINV_SaleProvider sqlINV_SaleProvider = new SqlINV_SaleProvider(); iNV_Sale = sqlINV_SaleProvider.GetINV_SaleByIteamID(IteamID); return iNV_Sale; }
protected void btnUpdate_Click(object sender, EventArgs e) { try { INV_Sale iNV_Sale = new INV_Sale (); iNV_Sale.SaleID= int.Parse(Request.QueryString["ID"].ToString()); iNV_Sale.CampusID= int.Parse(ddlCampusID.SelectedValue); iNV_Sale.InvoiceNo= txtInvoiceNo.Text; iNV_Sale.IteamID= int.Parse(ddlIteamID.SelectedValue); iNV_Sale.Quantity= decimal.Parse(txtQuantity.Text); iNV_Sale.Warrenty= int.Parse(txtWarrenty.Text); iNV_Sale.UnitPrice= decimal.Parse(txtUnitPrice.Text); iNV_Sale.SaleDate= DateTime.Parse(txtSaleDate.Text); iNV_Sale.Remark= txtRemark.Text; iNV_Sale.AddedBy= Profile.card_id; iNV_Sale.AddedDate= DateTime.Now; iNV_Sale.UpdatedBy= Profile.card_id; iNV_Sale.UpdatedDate= DateTime.Now; bool resutl =INV_SaleManager.UpdateINV_Sale(iNV_Sale); }catch(Exception ex){}Response.Redirect("AdminDisplayINV_Sale.aspx"); }
public bool UpdateINV_Sale(INV_Sale iNV_Sale) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("UpdateINV_Sale", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@SaleID", SqlDbType.Int).Value = iNV_Sale.SaleID; cmd.Parameters.Add("@CampusID", SqlDbType.Int).Value = iNV_Sale.CampusID; cmd.Parameters.Add("@InvoiceNo", SqlDbType.NVarChar).Value = iNV_Sale.InvoiceNo; cmd.Parameters.Add("@IteamID", SqlDbType.Int).Value = iNV_Sale.IteamID; cmd.Parameters.Add("@Quantity", SqlDbType.Decimal).Value = iNV_Sale.Quantity; cmd.Parameters.Add("@Warrenty", SqlDbType.Int).Value = iNV_Sale.Warrenty; cmd.Parameters.Add("@UnitPrice", SqlDbType.Decimal).Value = iNV_Sale.UnitPrice; cmd.Parameters.Add("@SaleDate", SqlDbType.DateTime).Value = iNV_Sale.SaleDate; cmd.Parameters.Add("@Remark", SqlDbType.NText).Value = iNV_Sale.Remark; //cmd.Parameters.Add("@Remark", SqlDbType.NText).Value = iNV_Sale.Remark; //cmd.Parameters.Add("@Remark", SqlDbType.NText).Value = iNV_Sale.Remark; cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = iNV_Sale.UpdatedBy; cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = iNV_Sale.UpdatedDate; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public INV_Sale GetINV_SaleFromReader(IDataReader reader) { try { INV_Sale iNV_Sale = new INV_Sale ( DataAccessObject.IsNULL<int>(reader["SaleID"]), DataAccessObject.IsNULL<int>(reader["CampusID"]), DataAccessObject.IsNULL<string>(reader["InvoiceNo"]), DataAccessObject.IsNULL<int>(reader["IteamID"]), DataAccessObject.IsNULL<decimal>(reader["Quantity"]), DataAccessObject.IsNULL<int>(reader["Warrenty"]), DataAccessObject.IsNULL<decimal>(reader["UnitPrice"]), DataAccessObject.IsNULL<DateTime>(reader["SaleDate"]), DataAccessObject.IsNULL<string>(reader["Remark"]), DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]), DataAccessObject.IsNULL<string>(reader["UpdatedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["UpdatedDate"]) ); return iNV_Sale; } catch(Exception ex) { return null; } }
public static int InsertINV_Sale(INV_Sale iNV_Sale) { SqlINV_SaleProvider sqlINV_SaleProvider = new SqlINV_SaleProvider(); return sqlINV_SaleProvider.InsertINV_Sale(iNV_Sale); }
public static bool UpdateINV_Sale(INV_Sale iNV_Sale) { SqlINV_SaleProvider sqlINV_SaleProvider = new SqlINV_SaleProvider(); return sqlINV_SaleProvider.UpdateINV_Sale(iNV_Sale); }
private void showINV_SaleData() { INV_Sale iNV_Sale = new INV_Sale (); iNV_Sale = INV_SaleManager.GetINV_SaleBySaleID(Int32.Parse(Request.QueryString["ID"])); ddlCampusID.SelectedValue =iNV_Sale.CampusID.ToString(); txtInvoiceNo.Text =iNV_Sale.InvoiceNo.ToString(); ddlIteamID.SelectedValue =iNV_Sale.IteamID.ToString(); txtQuantity.Text =iNV_Sale.Quantity.ToString(); txtWarrenty.Text =iNV_Sale.Warrenty.ToString(); txtUnitPrice.Text =iNV_Sale.UnitPrice.ToString(); txtSaleDate.Text =iNV_Sale.SaleDate.ToString(); txtRemark.Text =iNV_Sale.Remark.ToString(); string txtUpdatedBy_Text =iNV_Sale.UpdatedBy.ToString(); string txtUpdatedDate_Text =iNV_Sale.UpdatedDate.ToString(); }