public string usp_zlk_Make_Ins(string MakeName)
{
DataMaven dm = new DataMaven();
dm.SetSP("usp_zlk_Make_Ins");
dm.AddParameter("@MakeName", SqlDbType.VarChar, ParameterDirection.Input, MakeName);
dm.AddParameter("@UserID", SqlDbType.Int, ParameterDirection.Input, Util.LoggedInUser());
dm.AddParameter("@NewID", SqlDbType.Int, ParameterDirection.Output, null);
SqlParameterCollection parms = dm.ExecNonQuery();
return(parms["@NewID"].Value.ToString());
}
protected int BusinessDayCount(DateTime StartDate, DateTime EndDate)
{
DataMaven dm = new DataMaven();
dm.SetSP("usp_BusinessDayCount_Sel");
dm.AddParameter("@StartDate", SqlDbType.DateTime, ParameterDirection.Input, StartDate);
dm.AddParameter("@EndDate", SqlDbType.DateTime, ParameterDirection.Input, EndDate);
dm.AddParameter("@DayCount", SqlDbType.Int, ParameterDirection.Output, null);
SqlParameterCollection parms = dm.ExecNonQuery();
return((int)parms["@DayCount"].Value);
}
public static void LoadList(RadioButtonList rdo, string sp, string TextField, string ValueField, string[,] Parms = null)
{
try
{
DataMaven dm = new DataMaven();
System.Data.SqlDbType dType = default(System.Data.SqlDbType);
DataTable dt = null;
int i = 0;
dm.SetSP(sp);
if ((Parms != null))
{
for (i = 0; i <= Parms.GetUpperBound(1); i++)
{
if ((Parms != null))
{
dType = (SqlDbType)Parms.GetValue(i, 0);
dm.AddParameter(Parms.GetValue(i, 1).ToString(), dType, ParameterDirection.Input, Parms.GetValue(i, 2));
}
}
}
dt = dm.ExecToDataTable();
// Bind data to RadioButtonList
rdo.DataSource = dt;
rdo.DataTextField = TextField;
rdo.DataValueField = ValueField;
rdo.DataBind();
}
catch (Exception ex)
{
// Display error message
Util.jsErrorAlert(ex.Message);
}
}