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