public string GetStoreTree(string parent) { DataTable dt = new DataTable(); string returntxt = string.Empty; MySQLConnection con = new MySQLConnection(); try { con.open(); SqlCommand cmd = new SqlCommand("usp_DisplayNTree", con.con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter parm1 = new SqlParameter("@Parent", Convert.ToInt32(parent)); parm1.Direction = ParameterDirection.Input; SqlParameter parm2 = new SqlParameter("@TreeFor", Convert.ToInt32(1)); parm2.Direction = ParameterDirection.Input; SqlParameter parm = new SqlParameter("@myReturnString", SqlDbType.VarChar, 50000); parm.Direction = ParameterDirection.Output; cmd.Parameters.Add(parm1); cmd.Parameters.Add(parm2); cmd.Parameters.Add(parm); cmd.ExecuteNonQuery(); returntxt = Convert.ToString(cmd.Parameters["@myReturnString"].Value); cmd.Dispose(); } catch (Exception ex) { } finally { con.Close(); } return(returntxt); }
public string EstatePlotInstallmentsCreate(string fromdate, string todate, string amount, string noOfInstallments) { DataTable dt = new DataTable(); string returntxt = string.Empty; MySQLConnection con = new MySQLConnection(); try { con.open(); SqlCommand cmd = new SqlCommand("usp_EstatePlotCreateInstallments", con.con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@NoOfInstallments", noOfInstallments); cmd.Parameters.AddWithValue("@Amount", amount); cmd.Parameters.AddWithValue("@startingDate", fromdate); cmd.Parameters.AddWithValue("@endingDate", todate); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); if (dt != null && dt.Rows.Count > 0) { returntxt = Convert.ToString(dt.Rows[0]["FinalInstallments"]); } cmd.Dispose(); } catch (Exception ex) { } finally { con.Close(); } return(returntxt); }