public List <OmanFloat> GetOmanFloat(string orderno)
{
MySqlConnection con = new MySqlConnection(ConnectionString);
try
{
MySqlCommand com = new MySqlCommand("GetOmanInformaion", con);
com.CommandType = System.Data.CommandType.StoredProcedure;
com.Parameters.Add(new MySqlParameter("VarOrderNo", orderno));
List <OmanFloat> OmanFloatList = new List <OmanFloat>();
con.Open();
MySqlDataReader reader = com.ExecuteReader();
while (reader.Read())
{
OmanFloat OmnFloat = new OmanFloat();
OmnFloat.OrderNo = reader["OrderNo"].ToString();
DateTime?dt2 = (reader["OrderDate"] == System.DBNull.Value) ? (DateTime?)null : Convert.ToDateTime(reader["OrderDate"]);
OmnFloat.OrderDate = dt2;
//OmnFloat.OrderDate = Convert.ToDateTime(reader["OrderDate"]);
OmnFloat.MemberName = reader["MemberName"].ToString();
//OmnFloat.PaymentstoOman = Convert.ToDouble(reader["PaymentstoOman"]);
OmnFloat.Totalcost = Convert.ToDouble(reader["Totalcost"]);
OmnFloat.Deliveryfees = Convert.ToDouble(reader["Deliveryfees"]);
OmnFloat.TotalCostwithDelivery = Convert.ToDouble(reader["TotalCostwithDelivery"]);
//OmnFloat.TotalRemainingAmount = Convert.ToDouble(reader["TotalRemainingAmount"]);
OmnFloat.Status = reader["Status"].ToString();
DateTime?dt = (reader["DeliveryDate"] == System.DBNull.Value) ? (DateTime?)null : Convert.ToDateTime(reader["DeliveryDate"]);
OmnFloat.DeliveryDate = dt;
OmnFloat.CardTypeandAmount = reader["CardTypeandAmount"].ToString();
OmnFloat.Quantity = Convert.ToInt32(reader["Quantity"]);
// DateTime? dt1 = (reader["Dateofpayment"] == System.DBNull.Value) ? (DateTime?)null : Convert.ToDateTime(reader["Dateofpayment"]);
//OmnFloat.Dateofpayment = dt1;
OmanFloatList.Add(OmnFloat);
}
//lblTotalAmount.Text = Convert.ToDouble(reader["TotalRemainingAmount"]);
con.Close();
return(OmanFloatList);
}
catch
{
con.Close();
return(null);
}
}
protected void gvOF_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
OmanFloatDAL OFDAL = new OmanFloatDAL();
OmanFloat com = new OmanFloat();
OFDAL.ConnectionString = ConfigurationManager.ConnectionStrings["MySQLConn"].ToString();
com.OrderNo = (gvOF.Rows[e.RowIndex].FindControl("lblOrderNo") as Label).Text;
com.OrderDate = Convert.ToDateTime((gvOF.Rows[e.RowIndex].FindControl("lblOrderDate") as Label).Text);
com.MemberName = (gvOF.Rows[e.RowIndex].FindControl("lblMemberName") as Label).Text;
com.Totalcost = Convert.ToDouble((gvOF.Rows[e.RowIndex].FindControl("tbTotalcost") as TextBox).Text);
com.Deliveryfees = Convert.ToDouble((gvOF.Rows[e.RowIndex].FindControl("tbDeliveryfees") as TextBox).Text);
com.TotalCostwithDelivery = Convert.ToDouble((gvOF.Rows[e.RowIndex].FindControl("tbTCWD") as TextBox).Text);
com.Status = (gvOF.Rows[e.RowIndex].FindControl("tbStatus") as TextBox).Text;
DateTime?DD = (((gvOF.Rows[e.RowIndex].FindControl("tbDD") as TextBox).Text) == "")? (DateTime?)null: Convert.ToDateTime(((gvOF.Rows[e.RowIndex].FindControl("tbDD") as TextBox).Text));
com.DeliveryDate = DD;
com.CardTypeandAmount = (gvOF.Rows[e.RowIndex].FindControl("tbCardTypeandAmount") as TextBox).Text;
com.Quantity = Convert.ToInt32((gvOF.Rows[e.RowIndex].FindControl("tbQuantity") as TextBox).Text);
OFDAL.InsertOmanFloat(com);
gvOF.EditIndex = -1;
GetOmanFloat();
}
public void InsertOmanFloat(OmanFloat omanFloat)
{
//Connection and Command objects.
MySqlConnection con = new MySqlConnection(ConnectionString);
MySqlCommand com = new MySqlCommand("UpsertOman", con);
//Procedure Parameters .
com.CommandType = System.Data.CommandType.StoredProcedure;
com.Parameters.Add(new MySqlParameter("VarOrderNo", omanFloat.OrderNo));
com.Parameters.Add(new MySqlParameter("VarOrderDate", omanFloat.OrderDate));
com.Parameters.Add(new MySqlParameter("VarMemberName", omanFloat.MemberName));
com.Parameters.Add(new MySqlParameter("VarTotalcost", omanFloat.Totalcost));
com.Parameters.Add(new MySqlParameter("VarDeliveryfees", omanFloat.Deliveryfees));
com.Parameters.Add(new MySqlParameter("VarTotalCostwithDelivery", omanFloat.TotalCostwithDelivery));
com.Parameters.Add(new MySqlParameter("VarStatus", omanFloat.Status));
com.Parameters.Add(new MySqlParameter("VarDeliveryDate", omanFloat.DeliveryDate));
com.Parameters.Add(new MySqlParameter("VarCardTypeandAmount", omanFloat.CardTypeandAmount));
com.Parameters.Add(new MySqlParameter("VarQuantity", omanFloat.Quantity));
//
con.Open();
com.ExecuteNonQuery();
con.Close();
}
