public void deleteProject(int ProjectId)
{
DLProject dlProject = new DLProject();
try
{
dlProject.deleteProject(ProjectId);
}
catch
{
throw;
}
finally
{
dlProject = null;
}
}
//public string DelDocument(int Projectid)
//{
// DLProject dlObjDelDoc = new DLProject();
// try
// {
// Result = dlObjDelDoc.DelDocument(Projectid );
// }
// catch(Exception ex)
// {
// Result = ex.Message.ToString();
// }
// finally
// {
// dlObjDelDoc = null;
// }
// return Result;
//}
public void delDocOnProject1(int intProjectId)
{
DLProject dlc = new DLProject();
try
{
dlc.delDocOnProject1(intProjectId);
}
catch
{
throw;
}
finally
{
dlc = null;
}
}
public void delUnselectClerk1(int intProjectID, int intSearchClerkID)
{
DLProject dle = new DLProject();
try
{
dle.delUnselectClerk1(intProjectID, intSearchClerkID);
}
catch
{
throw;
}
finally
{
dle = null;
}
}
public SqlDataReader getProjectDetailsForUpdate1(int intProjectId)
{
DLProject dlsr = new DLProject();
try
{
SqlDataReader dr = dlsr.getProjectDetailsForUpdate1( intProjectId);
return dr;
}
catch
{
throw;
}
finally
{
dlsr = null;
}
}
public SqlDataReader gridFillClientCaseStatusApprove1(string strClientName, string strCaseName, string strStatus, int intApprove)
{
DLProject dlsr = new DLProject();
try
{
SqlDataReader dr = dlsr.gridFillClientCaseStatusApprove1(strClientName,strCaseName,strStatus,intApprove);
return dr;
}
catch
{
throw;
}
finally
{
//dlsr = null;
}
}
public SqlDataReader getCaseName1(string strClientName)
{
DLProject dlsr = new DLProject();
try
{
SqlDataReader dr = dlsr.getCaseName1(strClientName);
return dr;
}
catch
{
throw;
}
finally
{
dlsr = null;
}
}
public string UpadateFileDelete(int projectid, string worddoc, string file)
{
DLProject dlDelFile = new DLProject();
try
{
Result = dlDelFile.UpadateFileDelete(projectid, worddoc, file);
}
catch
{
throw;
}
finally
{
//con.Close();
//con.Dispose();
}
return Result;
}
public SqlDataReader showSelectedServices1(int intProjectId)
{
DLProject dlsr = new DLProject();
try
{
SqlDataReader dr = dlsr.showSelectedServices1(intProjectId);
return dr;
}
catch
{
throw;
}
finally
{
dlsr = null;
}
}
public void saveSelectedEmp1(int intProjectID, int intEmployeeID, string strEmployeeName, DateTime dtStartDate, DateTime dtEndDate)
{
DLProject dle = new DLProject();
try
{
dle.saveSelectedEmp1(intProjectID, intEmployeeID, strEmployeeName, dtStartDate, dtEndDate);
}
catch
{
throw;
}
finally
{
dle = null;
}
}
public SqlDataReader gridFillStatus1(string strStatus)
{
DLProject dlsr = new DLProject();
try
{
SqlDataReader dr = dlsr.gridFillStatus1(strStatus);
return dr;
}
catch
{
throw;
}
finally
{
//dlsr = null;
}
}
public SqlDataReader isDelProjectUnChecked1()
{
DLProject dlc = new DLProject();
try
{
SqlDataReader dr = dlc.isDelProjectUnChecked1();
return dr;
}
catch
{
throw;
}
finally
{
//dlc = null;
}
}
public SqlDataReader getProject1()
{
DLProject dld = new DLProject();
try
{
SqlDataReader dr = dld.getProject1();
return dr;
}
catch
{
throw;
}
finally
{
dld = null;
}
}
public SqlDataAdapter getProjectClientName1(string strClientName)
{
SqlDataAdapter da = new SqlDataAdapter();
DLProject dltow = new DLProject();
try
{
dltow.getProjectClientName1(strClientName);
return da;
}
catch
{
throw;
}
finally
{
//dltow = null;
}
}
public SqlDataReader getEmpIdEmpGrid1(string strEmployeeCode)
{
DLProject dlsr = new DLProject();
try
{
SqlDataReader dr = dlsr.getEmpIdEmpGrid1(strEmployeeCode);
return dr;
}
catch
{
throw;
}
finally
{
dlsr = null;
}
}
public SqlDataReader getDocIdDocGrid1(string strDocument)
{
DLProject dlsr = new DLProject();
try
{
SqlDataReader dr = dlsr.getDocIdDocGrid1(strDocument);
return dr;
}
catch
{
throw;
}
finally
{
dlsr = null;
}
}
public SqlDataReader GetData(int LoginId)
{
DLProject dlc = new DLProject();
try
{
SqlDataReader dr = dlc.getData(LoginId);
return dr;
}
catch
{
throw;
}
finally
{
//dlc = null;
}
}
public SqlDataReader getClientName1()
{
DLProject dlc = new DLProject();
try
{
SqlDataReader dr = dlc.getClientName1();
return dr;
}
catch
{
throw;
}
finally
{
//dlc = null;
}
}
public SqlDataReader getClerkIdClerkGrid1(string strClerkName)
{
DLProject dlsr = new DLProject();
try
{
SqlDataReader dr = dlsr.getClerkIdClerkGrid1( strClerkName);
return dr;
}
catch
{
throw;
}
finally
{
dlsr = null;
}
}
public SqlDataReader isDelProjectCliStaCasChecked1(string strClientName, string strCaseName, string strStatus, int intIsDeleted)
{
DLProject dlc = new DLProject();
try
{
SqlDataReader dr = dlc.isDelProjectCliStaCasChecked1(strClientName, strCaseName, strStatus, intIsDeleted);
return dr;
}
catch
{
throw;
}
finally
{
//dlc = null;
}
}
public SqlDataReader getServiceForEmpClient1(int intClientID)
{
DLProject dlsr = new DLProject();
try
{
SqlDataReader dr = dlsr.getServiceForEmpClient1(intClientID);
return dr;
}
catch
{
throw;
}
finally
{
dlsr = null;
}
}
public void saveSelectedClerk1(int intProjectID, int intSearchClerkID, string strSearchClerkName, DateTime dtSearchStarts, DateTime dtSearchEnd)
{
DLProject dle = new DLProject();
try
{
dle.saveSelectedClerk1(intProjectID, intSearchClerkID, strSearchClerkName, dtSearchStarts, dtSearchEnd);
}
catch
{
throw;
}
finally
{
dle = null;
}
}
public SqlDataReader getServiceIdServiceGrid1(string strServiceName)
{
DLProject dlsr = new DLProject();
try
{
SqlDataReader dr = dlsr.getServiceIdServiceGrid1(strServiceName);
return dr;
}
catch
{
throw;
}
finally
{
dlsr = null;
}
}
public void saveSelectedDocumentBoy1(int intProjectID, int intDocumentboyID, string strDocumentboyName)
{
DLProject dle = new DLProject();
try
{
dle.saveSelectedDocumentBoy1( intProjectID, intDocumentboyID, strDocumentboyName);
}
catch
{
throw;
}
finally
{
dle = null;
}
}
public SqlDataReader getTypeOfWorkForProject1()
{
DLProject dlc = new DLProject();
try
{
SqlDataReader dr = dlc.getTypeOfWorkForProject1();
return dr;
}
catch
{
throw;
}
finally
{
//dlc = null;
}
}
public void saveSelectedServices1(int intProjectID, int intServiceID, string strServices, float floatPrice)
{
DLProject dle = new DLProject();
try
{
dle.saveSelectedServices1(intProjectID, intServiceID, strServices, floatPrice);
}
catch
{
throw;
}
finally
{
dle = null;
}
}
public SqlDataReader getTypWrkIdByWrk1(string strWork)
{
DLProject dlsr = new DLProject();
try
{
SqlDataReader dr = dlsr.getTypWrkIdByWrk1(strWork);
return dr;
}
catch
{
throw;
}
finally
{
dlsr = null;
}
}
public void delUnSelectDoc1(int intProjectID, int intDocumentID)
{
DLProject dle = new DLProject();
try
{
dle.delUnSelectDoc1(intProjectID, intDocumentID);
}
catch
{
throw;
}
finally
{
dle = null;
}
}
public SqlDataReader gridFillApprove1(int intApprove)
{
DLProject dlsr = new DLProject();
try
{
SqlDataReader dr = dlsr.gridFillApprove1(intApprove);
return dr;
}
catch
{
throw;
}
finally
{
dlsr = null;
}
}
public void updateProjects1(DateTime dtProjectDate, int intProjectId, string strClientName, int intTypeOfWorkID, string strTypeOfWork, string strCaseName, int intExternalWork, bool boolNeedSearch, string strRemarks, decimal decPrice, decimal decOtherCharges, decimal decTotalAmount, string strStatus, bool boolIsDeleted, int intApprove, decimal decServiceTax, string strReferenceNo, string strLoanNO, string strPropertyAddress, DateTime dt_softcopysent, DateTime dt_MISclient, DateTime dt_search_initiated, DateTime dt_search_received, DateTime dt_search_received_receipt, DateTime dt_hardcopysent, DateTime dt_pendingdocumentsrec, DateTime dt_pendingdocumentsresp, DateTime dt_finalreportsent, string strworddoc, string strfilename, string strbranch, decimal decloanamt,string strEmailID)
{
DLProject dlc = new DLProject();
try
{
dlc.updateProjects1(dtProjectDate, intProjectId, strClientName, intTypeOfWorkID, strTypeOfWork, strCaseName, intExternalWork, boolNeedSearch, strRemarks, decPrice, decOtherCharges, decTotalAmount, strStatus, boolIsDeleted, intApprove, decServiceTax, strReferenceNo, strLoanNO, strPropertyAddress, dt_softcopysent, dt_MISclient, dt_search_initiated, dt_search_received, dt_search_received_receipt, dt_hardcopysent, dt_pendingdocumentsrec, dt_pendingdocumentsresp, dt_finalreportsent, strworddoc, strfilename, strbranch, decloanamt, strEmailID);
}
catch
{
throw;
}
finally
{
dlc = null;
}
}
public void delUnSelectedServices1(int intProjectID, int intServiceID)
{
DLProject dle = new DLProject();
try
{
dle.delUnSelectedServices1(intProjectID, intServiceID);
}
catch
{
throw;
}
finally
{
dle = null;
}
}