public int Save_Update() //********************************Added 10/8/2015
{
CDbDrawingLog dbDt = new CDbDrawingLog();
string tmpDat;
int retVal = 0;
// tmpDat = GetDataString_Test();
tmpDat = GetDataString();
if (base.ID > 0)
{
// dbDt.SavePrev_Test(tmpDat);
dbDt.SavePrev(tmpDat);
retVal = base.ID;
}
else
{
//retVal = dbDt.SaveNew_Test(tmpDat);
base.ID = retVal;
}
dbDt = null;
return(retVal);
}
public static SqlDataReader GetExportListForDrawingLog(string dXml, string pXml, int sortCode, int drwgSpec)//*****************Added 10/2/2015
{
// CDbBudgetLine dbDt = new CDbBudgetLine();
// return dbDt.GetExportListByBudget(budID);
CDbDrawingLog dbDt = new CDbDrawingLog();
return(dbDt.GetDrawingLogMainByDeptListProjList_Test(dXml, pXml, sortCode, drwgSpec));
}
public void Load(int iID)
{
CDbDrawingLog dbDt = new CDbDrawingLog();
string tmpDat;
tmpDat = dbDt.GetByID(iID);
Clear();
if (tmpDat.Length > 0)
{
LoadVals(tmpDat);
}
dbDt = null;
}
public int SaveNewImport()
{
CDbDrawingLog dbDt = new CDbDrawingLog();
string tmpDat;
int retVal;
tmpDat = GetDataString();
retVal = dbDt.SaveNewImport(tmpDat);
base.ID = retVal;
dbDt = null;
return(retVal);
}
public int Save()
{
CDbDrawingLog dbDt = new CDbDrawingLog();
string tmpDat;
int retVal;
tmpDat = GetDataString();
if (base.ID > 0)
{
dbDt.SavePrev(tmpDat);
retVal = base.ID;
}
else
{
retVal = dbDt.SaveNew(tmpDat);
base.ID = retVal;
}
dbDt = null;
return(retVal);
}
public static dsDrawingLog GetDrawingLogMainByLeadList(string dXml, string lXml, int sortCode, int drwgSpec)
{
CDbDrawingLog dbDt = new CDbDrawingLog();
return(dbDt.GetDrawingLogMainByLeadList(dXml, lXml, sortCode, drwgSpec));
}
public static dsDrawingLog GetDrawingLogMainByDeptListProjList(string dXml, string pXml, int sortCode, int drwgSpec)
{
CDbDrawingLog dbDt = new CDbDrawingLog();
return(dbDt.GetDrawingLogMainByDeptListProjList(dXml, pXml, sortCode, drwgSpec));
}
public static SqlDataReader GetListAcctCodes() //************************Added 11/20
{
CDbDrawingLog dbDt = new CDbDrawingLog();
return(dbDt.GetListAcctCodes());
}
public static void DeleteDrawingLogByProject(int projID)
{
CDbDrawingLog dl = new CDbDrawingLog();
dl.DeleteDrawingLogByProject(projID);
}
public static dsDrawingLog GetCustomerDrawingLogMainByDeptListProjList(string dXml, string pXml, int sortCode)
{
CDbDrawingLog dbDt = new CDbDrawingLog();
return(dbDt.GetDrawingLogMainByDeptListProjList(dXml, pXml, sortCode, 0));
}
public static DataSet GetListByDeptLeadForUpdate(int deptID, int leadID)
{
CDbDrawingLog dbDt = new CDbDrawingLog();
return(dbDt.GetListbyDeptLeadForUpdate(deptID, leadID));
}
public static void UpdateHours(int lID, decimal budHrs, decimal percComp, decimal ernHrs, decimal remHrs)
{
CDbDrawingLog dbDt = new CDbDrawingLog();
dbDt.UpdateHours(lID, budHrs, percComp, ernHrs, remHrs);
}
public static SqlDataReader GetExportListForDrawingLog_Lead(string dXml, string lXml, int sortCode, int drwgSpec)//*****************Added10/2/2015
{
CDbDrawingLog dbDt = new CDbDrawingLog();
return(dbDt.GetDrawingLogMainByLeadList_Test(dXml, lXml, sortCode, drwgSpec));
}
public static DataSet GetListbyDeptProjForUpdate(int deptID, int projID, string wbs, bool sortByCAD)
{
CDbDrawingLog dbDt = new CDbDrawingLog();
return(dbDt.GetListbyDeptProjForUpdate(deptID, projID, wbs, true));
}
public static SqlDataReader GetList()
{
CDbDrawingLog dbDt = new CDbDrawingLog();
return(dbDt.GetList());
}
public static SqlDataReader GetWBSListByProject(int projectID)
{
CDbDrawingLog dbDt = new CDbDrawingLog();
return(dbDt.GetWBSListByProject(projectID));
}
public static SqlDataReader GetListbyDeptProjForTransNoTask(int deptID, int projID)
{
CDbDrawingLog dbDt = new CDbDrawingLog();
return(dbDt.GetListbyDeptProjForTransNoTask(deptID, projID));
}
public static dsDrawingLog GetCustomerDrawingLogForRprt(int deptID, int projID)
{
CDbDrawingLog dbDt = new CDbDrawingLog();
return(dbDt.GetDrawingLogForRprt(deptID, projID));
}
public static void UpdateProjectLead(int deptID, int projId, int projLeadID)
{
CDbDrawingLog dl = new CDbDrawingLog();
dl.UpdateProjectLead(deptID, projId, projLeadID);
}
public static dsDrawingLog GetCustomerDrawingLogMainByProjList(string pXml, int sortCode)
{
CDbDrawingLog dbDt = new CDbDrawingLog();
return((dsDrawingLog)dbDt.GetDrawingLogMainByProjList(pXml, sortCode, 0));
}
public static DataSet GetJobStatForRprt(int deptID, int projID)
{
CDbDrawingLog dbDt = new CDbDrawingLog();
return(dbDt.GetJobStatForRprt(deptID, projID));
}
public static dsDrawingLog GetCustomerDrawingLogMainByLeadList(string dXml, string lXml, int sortCode)
{
CDbDrawingLog dbDt = new CDbDrawingLog();
return(dbDt.GetDrawingLogMainByLeadList(dXml, lXml, sortCode, 0));
}
public static void Delete(int cID)
{
CDbDrawingLog dbDt = new CDbDrawingLog();
dbDt.Delete(cID);
}
public static bool DrawingLogExists(int projectID)
{
CDbDrawingLog dl = new CDbDrawingLog();
return(dl.DrawingLogExists(projectID));
}
public static DataSet GetJobStatListByDeptListProjList(string dXml, string pXml, int sortCode)
{
CDbDrawingLog dbDt = new CDbDrawingLog();
return(dbDt.GetJobStatListByDeptListProjList(dXml, pXml, sortCode));
}
public static string GetDescriptionByID(int lID)
{
CDbDrawingLog dl = new CDbDrawingLog();
return(dl.GetDescriptionByID(lID));
}
public static DataSet GetJobStatListByLeadList(string dXml, string lXml, int sortCode)
{
CDbDrawingLog dbDt = new CDbDrawingLog();
return(dbDt.GetJobStatListByLeadList(dXml, lXml, sortCode));
}
public static DataSet GetJobStatListByDeptID(int deptID, int sortCode)
{
CDbDrawingLog dbDt = new CDbDrawingLog();
return(dbDt.GetJobStatListByDeptID(deptID, sortCode));
}
public static SqlDataReader GetListByDeptProj(int dID, int pID, string wbs, int sortCol, bool sortAsc)
{
CDbDrawingLog dbDt = new CDbDrawingLog();
return(dbDt.GetListbyDeptProj(dID, pID, wbs, sortCol, sortAsc));
}