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