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