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