public static ACC_VoucherIteam GetCOMN_RowStatusByRowStatusID(int RowStatusID) { ACC_VoucherIteam aCC_VoucherIteam = new ACC_VoucherIteam(); SqlACC_VoucherIteamProvider sqlACC_VoucherIteamProvider = new SqlACC_VoucherIteamProvider(); aCC_VoucherIteam = sqlACC_VoucherIteamProvider.GetACC_VoucherIteamByRowStatusID(RowStatusID); return aCC_VoucherIteam; }
public static ACC_VoucherIteam GetACC_VoucherIteamByVoucherIteamID(int VoucherIteamID) { ACC_VoucherIteam aCC_VoucherIteam = new ACC_VoucherIteam(); SqlACC_VoucherIteamProvider sqlACC_VoucherIteamProvider = new SqlACC_VoucherIteamProvider(); aCC_VoucherIteam = sqlACC_VoucherIteamProvider.GetACC_VoucherIteamByVoucherIteamID(VoucherIteamID); return aCC_VoucherIteam; }
protected void btnUpdate_Click(object sender, EventArgs e) { ACC_VoucherIteam aCC_VoucherIteam = new ACC_VoucherIteam (); aCC_VoucherIteam.VoucherIteamID= int.Parse(Request.QueryString["ID"].ToString()); aCC_VoucherIteam.VoucherIteamName= txtVoucherIteamName.Text; aCC_VoucherIteam.VoucherID= int.Parse(ddlVoucherID.SelectedValue); aCC_VoucherIteam.IteamCode= txtIteamCode.Text; aCC_VoucherIteam.Description= txtDescription.Text; aCC_VoucherIteam.UnitPrice= decimal.Parse(txtUnitPrice.Text); aCC_VoucherIteam.Quantity= decimal.Parse(txtQuantity.Text); aCC_VoucherIteam.AddedBy= Profile.card_id; aCC_VoucherIteam.AddedDate= DateTime.Now; aCC_VoucherIteam.UpdatedBy= Profile.card_id; aCC_VoucherIteam.UpdateDate= DateTime.Now; aCC_VoucherIteam.RowStatusID= int.Parse(ddlRowStatusID.SelectedValue); bool resutl =ACC_VoucherIteamManager.UpdateACC_VoucherIteam(aCC_VoucherIteam); Response.Redirect("AdminDisplayACC_VoucherIteam.aspx"); }
private void showACC_VoucherIteamData() { ACC_VoucherIteam aCC_VoucherIteam = new ACC_VoucherIteam (); aCC_VoucherIteam = ACC_VoucherIteamManager.GetACC_VoucherIteamByVoucherIteamID(Int32.Parse(Request.QueryString["ID"])); txtVoucherIteamName.Text =aCC_VoucherIteam.VoucherIteamName.ToString(); ddlVoucherID.SelectedValue =aCC_VoucherIteam.VoucherID.ToString(); txtIteamCode.Text =aCC_VoucherIteam.IteamCode.ToString(); txtDescription.Text =aCC_VoucherIteam.Description.ToString(); txtUnitPrice.Text =aCC_VoucherIteam.UnitPrice.ToString(); txtQuantity.Text =aCC_VoucherIteam.Quantity.ToString(); ddlRowStatusID.SelectedValue =aCC_VoucherIteam.RowStatusID.ToString(); }
public static int InsertACC_VoucherIteam(ACC_VoucherIteam aCC_VoucherIteam) { SqlACC_VoucherIteamProvider sqlACC_VoucherIteamProvider = new SqlACC_VoucherIteamProvider(); return sqlACC_VoucherIteamProvider.InsertACC_VoucherIteam(aCC_VoucherIteam); }
public static bool UpdateACC_VoucherIteam(ACC_VoucherIteam aCC_VoucherIteam) { SqlACC_VoucherIteamProvider sqlACC_VoucherIteamProvider = new SqlACC_VoucherIteamProvider(); return sqlACC_VoucherIteamProvider.UpdateACC_VoucherIteam(aCC_VoucherIteam); }
public ACC_VoucherIteam GetACC_VoucherIteamFromReader(IDataReader reader) { try { ACC_VoucherIteam aCC_VoucherIteam = new ACC_VoucherIteam ( DataAccessObject.IsNULL<int>(reader["VoucherIteamID"]), DataAccessObject.IsNULL<string>(reader["VoucherIteamName"]), DataAccessObject.IsNULL<int>(reader["VoucherID"]), DataAccessObject.IsNULL<string>(reader["IteamCode"]), DataAccessObject.IsNULL<string>(reader["Description"]), DataAccessObject.IsNULL<decimal>(reader["UnitPrice"]), DataAccessObject.IsNULL<decimal>(reader["Quantity"]), DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]), DataAccessObject.IsNULL<string>(reader["UpdatedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["UpdateDate"]), DataAccessObject.IsNULL<int>(reader["RowStatusID"]) ); return aCC_VoucherIteam; } catch(Exception ex) { return null; } }
public bool UpdateACC_VoucherIteam(ACC_VoucherIteam aCC_VoucherIteam) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("UpdateACC_VoucherIteam", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@VoucherIteamID", SqlDbType.Int).Value = aCC_VoucherIteam.VoucherIteamID; cmd.Parameters.Add("@VoucherIteamName", SqlDbType.NVarChar).Value = aCC_VoucherIteam.VoucherIteamName; cmd.Parameters.Add("@VoucherID", SqlDbType.Int).Value = aCC_VoucherIteam.VoucherID; cmd.Parameters.Add("@IteamCode", SqlDbType.NVarChar).Value = aCC_VoucherIteam.IteamCode; cmd.Parameters.Add("@Description", SqlDbType.NText).Value = aCC_VoucherIteam.Description; cmd.Parameters.Add("@UnitPrice", SqlDbType.Decimal).Value = aCC_VoucherIteam.UnitPrice; cmd.Parameters.Add("@Quantity", SqlDbType.Decimal).Value = aCC_VoucherIteam.Quantity; cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = aCC_VoucherIteam.UpdatedBy; cmd.Parameters.Add("@UpdateDate", SqlDbType.DateTime).Value = aCC_VoucherIteam.UpdateDate; cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = aCC_VoucherIteam.RowStatusID; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }