protected void GVFloat_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
FloatAmountDAL floatDAL = new FloatAmountDAL {
ConnectionString = ConfigurationManager.ConnectionStrings["MySQLTest"].ToString()
};
Float TheFloat = new Float()
{
OrderNo = (GVFloat.Rows[e.RowIndex].FindControl("LblFloatOrderNo") as Label).Text,
OrderDate = DateTime.Parse((GVFloat.Rows[e.RowIndex].FindControl("LblFloatOrderDate") as Label).Text),
MemberName = (GVFloat.Rows[e.RowIndex].FindControl("LblFloatMemberName") as Label).Text,
Totalcost = Double.Parse((GVFloat.Rows[e.RowIndex].FindControl("LblFloatCost") as Label).Text),
Deliveryfees = Double.Parse((GVFloat.Rows[e.RowIndex].FindControl("LblFloatFees") as Label).Text),
Status = (GVFloat.Rows[e.RowIndex].FindControl("DLLStatusList") as DropDownList).Text,
TotalCostwithDelivery = Double.Parse((GVFloat.Rows[e.RowIndex].FindControl("LblFloatTotal") as Label).Text),
CardTypeandAmount = (GVFloat.Rows[e.RowIndex].FindControl("LblFloatProduct") as Label).Text,
Quantity = Int32.Parse((GVFloat.Rows[e.RowIndex].FindControl("LblFloatQuantity") as Label).Text),
DeliveryDate = ((GVFloat.Rows[e.RowIndex].FindControl("TxtFloatDeliveryDate") as TextBox).Text == string.Empty) ? (DateTime?)null : DateTime.Parse((GVFloat.Rows[e.RowIndex].FindControl("TxtFloatDeliveryDate") as TextBox).Text)
};
floatDAL.InsertFloat(TheFloat);
GVFloat.EditIndex = -1;
FetchFloat();
}
protected void FetchFloat()
{
FloatAmountDAL theFloat = new FloatAmountDAL {
ConnectionString = ConfigurationManager.ConnectionStrings["MySQLTest"].ToString()
};
GVFloat.DataSource = theFloat.GetFloat(null);
GVFloat.DataBind();
}
protected void FetchAmount()
{
FloatAmountDAL theAmount = new FloatAmountDAL {
ConnectionString = ConfigurationManager.ConnectionStrings["MySQLTest"].ToString()
};
Double TotalAmount = Convert.ToDouble(theAmount.GetTotalAmount());
LblTotalAmount.Text = "Total remaining amount: " + TotalAmount;
GVAmount.DataSource = theAmount.GetAmount();
GVAmount.DataBind();
}
protected void GVFloat_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
FloatAmountDAL floatDAL = new FloatAmountDAL {
ConnectionString = ConfigurationManager.ConnectionStrings["MySQLTest"].ToString()
};
string OrderNo = GVFloat.DataKeys[e.RowIndex].Values["OrderNo"].ToString();
floatDAL.DeleteFloat(OrderNo);
FetchFloat();
}
protected void GVAmount_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
FloatAmountDAL amountDAL = new FloatAmountDAL {
ConnectionString = ConfigurationManager.ConnectionStrings["MySQLTest"].ToString()
};
string ID = GVAmount.DataKeys[e.RowIndex].Values["ID"].ToString();
amountDAL.DeleteAmount(ID);
FetchAmount();
}
protected void btnInsert_Click(object sender, EventArgs e)
{
FloatAmountDAL amountDAL = new FloatAmountDAL {
ConnectionString = ConfigurationManager.ConnectionStrings["MySQLTest"].ToString()
};
Amount TheAmount = new Amount();
TheAmount.PaymentstoOman = Convert.ToDouble(TxtAddPaymentAmount.Text);
TheAmount.Dateofpayment = (TxtAddPaymentDate.Text == string.Empty) ? (DateTime?)null : DateTime.Parse(TxtAddPaymentDate.Text);
amountDAL.InsertAmount(TheAmount);
FetchAmount();
}
protected void GVAmount_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
FloatAmountDAL amountDAL = new FloatAmountDAL {
ConnectionString = ConfigurationManager.ConnectionStrings["MySQLTest"].ToString()
};
Amount TheAmount = new Amount();
TheAmount.ID = Convert.ToInt32(GVAmount.DataKeys[e.RowIndex].Values["ID"].ToString());
TheAmount.PaymentstoOman = Convert.ToDouble((GVAmount.Rows[e.RowIndex].FindControl("TxtAmountPayment") as TextBox).Text);
TheAmount.Dateofpayment = ((GVAmount.Rows[e.RowIndex].FindControl("TxtAmountPaymentDate") as TextBox).Text == string.Empty) ? (DateTime?)null : DateTime.Parse((GVAmount.Rows[e.RowIndex].FindControl("TxtAmountPaymentDate") as TextBox).Text);
amountDAL.InsertAmount(TheAmount);
GVAmount.EditIndex = -1;
FetchAmount();
}
