public UserDetails Login(string userName, string password, int loginAttempt)
{
SqlParameter[] param = new SqlParameter[] { new SqlParameter("@cUserIdentifier", userName),
new SqlParameter("@cUserPassword", password),
new SqlParameter("@iLoginAttempt", loginAttempt) };
userInformation = new UserDetails();
if (objConnection.Connection.State == ConnectionState.Closed)
{
objConnection.Connection.Open();
}
reader = objConnection.ExecuteDataSetQuery(clsConstant.SP_AUTHENTICATION_WEB_USER, CommandType.StoredProcedure, param);
if (reader.Tables[0] != null && reader.Tables[0].Rows.Count > 0)
{
//------------------------
userInformation.UserID = Convert.ToInt32(reader.Tables[0].Rows[0][0].ToString());
userInformation.FirstName = reader.Tables[0].Rows[0][1].ToString();
userInformation.LastName = reader.Tables[0].Rows[0][2].ToString();
userInformation.DesignationID = Convert.ToInt32(reader.Tables[0].Rows[0][4].ToString());
// userInformation.PostalCode = reader.GetValue(5).ToString();
userInformation.Telephone = reader.Tables[0].Rows[0][5].ToString();
userInformation.CellPhone = reader.Tables[0].Rows[0][6].ToString();
//userInformation.Fax = reader.GetValue(8).ToString();
userInformation.EmailID = reader.Tables[0].Rows[0][7].ToString();
userInformation.AgencyID = Convert.ToInt32(reader.Tables[0].Rows[0][8].ToString());
userInformation.SkypeID = reader.Tables[0].Rows[0][9].ToString();
userInformation.UserActiive = Convert.ToBoolean(reader.Tables[0].Rows[0][10].ToString());
userInformation.ParentUserID = Convert.ToInt32(reader.Tables[0].Rows[0][11].ToString());
userInformation.SuperUser = Convert.ToBoolean(reader.Tables[0].Rows[0][12].ToString());
userInformation.userNm = reader.Tables[0].Rows[0][14].ToString();
userInformation.Agency = reader.Tables[0].Rows[0][15].ToString();
userInformation.Designation = reader.Tables[0].Rows[0][16].ToString();
userInformation.AgencyName = reader.Tables[0].Rows[0][17].ToString();
userInformation.EAP = reader.Tables[0].Rows[0][18].ToString();
userInformation.MDBType = reader.Tables[0].Rows[0][20].ToString();
}
if (reader.Tables[1] != null && reader.Tables[1].Rows.Count > 0)
{
List <Role> listRole = new List <Role>();
Role objRole = null;
foreach (DataRow row in reader.Tables[1].Rows)
{
objRole = new Role();
objRole.RoleDescription = row[1].ToString();
objRole.RoleID = Convert.ToInt32(row[0]);
listRole.Add(objRole);
}
userInformation.Roles = listRole;
}
return(userInformation);
}
public DataSet getUsersforrejectApprove(int docidvalue)
{
SqlParameter[] param = new SqlParameter[] { new SqlParameter("@DocID", docidvalue) };
DataSet ds = objConnection.ExecuteDataSetQuery(clsConstant.SP_GET_USER_FORAPPREJ, CommandType.StoredProcedure, param);
return(ds);
}
public DataSet LoadLinkPipeLineData(int PortFolioID)
{
//SP_GetPortfolioPipleWise
DataSet ds = new DataSet();
try
{//@iPipelineID
SqlParameter[] Param = new SqlParameter[]
{
new SqlParameter("@iPipelineID", PortFolioID)
};
dataAcess = new SqlDataAccess(clsConstant.DBCONSTRING);
if (dataAcess.Connection.State == ConnectionState.Closed)
{
dataAcess.Connection.Open();
}
ds = dataAcess.ExecuteDataSetQuery(clsConstant.SP_GetPortfolioPipleWise, CommandType.StoredProcedure, Param);
dataAcess.Connection.Close();
return(ds);
}
catch
{
return(ds);
}
}
public DataSet LoadMCGrid(int MCID)
{
//
DataSet ds = new DataSet();
try
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@MCID", MCID)
};
dataAcess = new SqlDataAccess(clsConstant.DBCONSTRING);
if (dataAcess.Connection.State == ConnectionState.Closed)
{
dataAcess.Connection.Open();
}
ds = dataAcess.ExecuteDataSetQuery("[GETMCCompMemberMCIDWiseWB]", CommandType.StoredProcedure, param);
dataAcess.Connection.Close();
return(ds);
}
catch
{
return(ds);
}
}
public DataSet GetDegination(int AgencyID)
{
//
DataSet ds = new DataSet();
try
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@iAgencyId", AgencyID)
};
dataAcess = new SqlDataAccess(clsConstant.DBCONSTRING);
if (dataAcess.Connection.State == ConnectionState.Closed)
{
dataAcess.Connection.Open();
}
ds = dataAcess.ExecuteDataSetQuery(clsConstant.SP_getAgencyWiseDesignation, CommandType.StoredProcedure, param);
dataAcess.Connection.Close(); //close connection
return(ds);
}
catch
{
return(ds);
}
}
public DataSet GetPreviousPortFolioData(string PortFolioID)
{
DataSet ds = new DataSet();
try
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@iPortfolio", PortFolioID)
};
dataAcess = new SqlDataAccess(clsConstant.DBCONSTRING);
if (dataAcess.Connection.State == ConnectionState.Closed)
{
dataAcess.Connection.Open();
}
ds = dataAcess.ExecuteDataSetQuery("GetPreviousPortfolioData", CommandType.StoredProcedure, param);
dataAcess.Connection.Close();
return(ds);
}
catch
{
return(ds);
}
}
public DataSet GetRecords(string Name)
{
string desgn = string.Empty;
DataSet ds = new DataSet();
try
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@status", "display"),
new SqlParameter("@Id", Name),
// new SqlParameter("@DESIG",desgn),
//new SqlParameter("@Search","s")
};
dataAcess = new SqlDataAccess(clsConstant.DBCONSTRING);
if (dataAcess.Connection.State == ConnectionState.Closed)
{
dataAcess.Connection.Open();
}
ds = dataAcess.ExecuteDataSetQuery(clsConstant.SP_MCM_OPERATIONWB, CommandType.StoredProcedure, param);
dataAcess.Connection.Close(); //close connection
return(ds);
}
catch
{
return(ds);
}
}
public DataSet GetAgencyDetail(string OfficalName, string Agency, string tblType)
{
DataSet ds = new DataSet();
//string[] arrNameDesig = OfficalName.Split('-');
//OfficalName = arrNameDesig[1];
string userid = OfficalName;
try
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@UserId", userid),
new SqlParameter("@tbltype", tblType)
};
dataAcess = new SqlDataAccess(clsConstant.DBCONSTRING);
if (dataAcess.Connection.State == ConnectionState.Closed)
{
dataAcess.Connection.Open();
}
ds = dataAcess.ExecuteDataSetQuery(clsConstant.SP_GetUserDesignation, CommandType.StoredProcedure, param);
dataAcess.Connection.Close(); //close connection
return(ds);
}
catch
{
return(ds);
}
}
public DataSet ShowData(string varchar)
{
dataAcess = new SqlDataAccess("TA7511DBConnString");
SqlParameter[] param = new SqlParameter[] { new SqlParameter("@filterString", varchar) };
ds = dataAcess.ExecuteDataSetQuery(clsConstant.SP_SELECT_PERFORMANCE_LOAN_FILTER, CommandType.StoredProcedure, param);
return(ds);
}
public DataSet GetRecords()
{
DataSet ds = new DataSet();
try
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@status", "display")
};
dataAcess = new SqlDataAccess(clsConstant.DBCONSTRING);
if (dataAcess.Connection.State == ConnectionState.Closed)
{
dataAcess.Connection.Open();
}
ds = dataAcess.ExecuteDataSetQuery(clsConstant.SP_MCM_OPERATIONWB, CommandType.StoredProcedure, param);
dataAcess.Connection.Close(); //close connection
return(ds);
}
catch
{
return(ds);
}
}
public DataSet GetMCRequestFillData(string MCID)
{
DataSet ds = new DataSet();
try
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@MCID", MCID)
};
dataAcess = new SqlDataAccess(clsConstant.DBCONSTRING);
if (dataAcess.Connection.State == ConnectionState.Closed)
{
dataAcess.Connection.Open();
}
// ds = dataAcess.ExecuteDataSetQuery(clsConstant.SP_SELECT_FOR_MC_REQUEST_FILL_WB, CommandType.StoredProcedure, param);
ds = dataAcess.ExecuteDataSetQuery("sp_SelectForMCRequestFillWB", CommandType.StoredProcedure, param);
dataAcess.Connection.Close();
return(ds);
}
catch
{
return(ds);
}
}
public DataSet GetUserWiseDesignationList(int UserID)
{
DataSet ds = new DataSet();
try
{
SqlParameter[] param = new SqlParameter[]
{
//
// new SqlParameter("@AgencyName",AgencyID)
new SqlParameter("@UserId", UserID)
};
dataAcess = new SqlDataAccess(clsConstant.DBCONSTRING);
if (dataAcess.Connection.State == ConnectionState.Closed)
{
dataAcess.Connection.Open();
}
//
// ds = dataAcess.ExecuteDataSetQuery(clsConstant.SP_GetAgencyWiseName, CommandType.StoredProcedure, param);
ds = dataAcess.ExecuteDataSetQuery(clsConstant.SP_GetUserDesignation, CommandType.StoredProcedure, param);
dataAcess.Connection.Close(); //close connection
return(ds);
}
catch
{
return(ds);
}
}
public DataSet GetContractAward(int contractAwardID)
{
SqlDataAccess dataAcess = new SqlDataAccess("TA7511DBConnString");
dataSet = dataAcess.ExecuteDataSetQuery(clsConstant.SP_SELECT_CONTRACT_AWARD_EDIT, CommandType.StoredProcedure, new SqlParameter("@contractAwardID", contractAwardID));
return(dataSet);
}
//
public DataSet LoadOffGrid(int MCID)
{
DataSet ds = new DataSet();
try
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@MCID", MCID)
};
dataAcess = new SqlDataAccess(clsConstant.DBCONSTRING);
if (dataAcess.Connection.State == ConnectionState.Closed)
{
dataAcess.Connection.Open();
}
ds = dataAcess.ExecuteDataSetQuery(clsConstant.SP_MCoffDataForDraft_Select, CommandType.StoredProcedure, param);
dataAcess.Connection.Close();
return(ds);
}
catch
{
return(ds);
}
}
public DataSet InsertIndOfficers(string FirstName, string LastName, string Desig, int AgencyName)
{
DataSet ds = new DataSet();
try
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@iAgencyID", AgencyName),
new SqlParameter("@VsFirstName", FirstName),
new SqlParameter("@vsLastName", LastName),
new SqlParameter("@flag", "i"),
new SqlParameter("@iDesigID", Desig)
};
dataAcess = new SqlDataAccess(clsConstant.DBCONSTRING);
if (dataAcess.Connection.State == ConnectionState.Closed)
{
dataAcess.Connection.Open();
}
ds = dataAcess.ExecuteDataSetQuery(clsConstant.SP_TransINDOfficer, CommandType.StoredProcedure, param);
dataAcess.Connection.Close();
return(ds);
}
catch (Exception ex)
{
return(ds);
}
}
public DataSet InsertMember(string FirstName, string LastName, string Nationality, string Designation, string Address)
{
DataSet ds = new DataSet();
try
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@status", "insert"),
new SqlParameter("@FirstNAME", FirstName),
new SqlParameter("@LastName", LastName),
new SqlParameter("@DESIG", Designation),
new SqlParameter("@nationality", Nationality),
new SqlParameter("@Address", Address)
};
dataAcess = new SqlDataAccess(clsConstant.DBCONSTRING);
if (dataAcess.Connection.State == ConnectionState.Closed)
{
dataAcess.Connection.Open();
}
ds = dataAcess.ExecuteDataSetQuery(clsConstant.SP_MCM_OPERATIONWB, CommandType.StoredProcedure, param);
dataAcess.Connection.Close();
return(ds);
}
catch (Exception ex)
{
return(ds);
}
}
public DataSet RejectEventWB(int EventID)
{
DataSet ds = new DataSet();
try
{
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@EventID", EventID),
};
dataAcess = new SqlDataAccess(clsConstant.DBCONSTRING);
if (dataAcess.Connection.State == ConnectionState.Closed)
{
dataAcess.Connection.Open();
}
ds = dataAcess.ExecuteDataSetQuery("RejectEventWB", CommandType.StoredProcedure, param);
dataAcess.Connection.Close(); //close connection
return(ds);
}
catch (Exception Ex)
{
return(ds);
}
}
public DataSet getLoanTADetails(int value, string Type)
{
DataSet ds = new DataSet();
try
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@taLoanID", value), new SqlParameter("@Type", Type)
};
dataAcess = new SqlDataAccess(clsConstant.DBCONSTRING);
if (dataAcess.Connection.State == ConnectionState.Closed)
{
dataAcess.Connection.Open();
}
ds = dataAcess.ExecuteDataSetQuery("[getMCPipelinePortAAADAta]", CommandType.StoredProcedure, param);
dataAcess.Connection.Close(); //close connection
return(ds);
}
catch
{
return(ds);
}
}
public DataSet BindDraftDataMC(int AgencyID)
{
//
DataSet ds = new DataSet();
try
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@iAgencyID", AgencyID)
};
dataAcess = new SqlDataAccess(clsConstant.DBCONSTRING);
if (dataAcess.Connection.State == ConnectionState.Closed)
{
dataAcess.Connection.Open();
}
ds = dataAcess.ExecuteDataSetQuery(clsConstant.SP_SelectMCDraft, CommandType.StoredProcedure, param);
dataAcess.Connection.Close();
return(ds);
}
catch
{
return(ds);
}
}
public DataSet GetNameDesigList(string AgencyID)
{
DataSet ds = new DataSet();
try
{
SqlParameter[] param = new SqlParameter[]
{
//
// new SqlParameter("@AgencyName",AgencyID)
new SqlParameter("@flag", "d"),
new SqlParameter("@iAgencyID", AgencyID)
};
dataAcess = new SqlDataAccess(clsConstant.DBCONSTRING);
if (dataAcess.Connection.State == ConnectionState.Closed)
{
dataAcess.Connection.Open();
}
//
// ds = dataAcess.ExecuteDataSetQuery(clsConstant.SP_GetAgencyWiseName, CommandType.StoredProcedure, param);
ds = dataAcess.ExecuteDataSetQuery(clsConstant.SP_TransINDOfficer, CommandType.StoredProcedure, param);
dataAcess.Connection.Close(); //close connection
return(ds);
}
catch
{
return(ds);
}
}
public DataSet LoadPortfolio(string Id)
{
DataSet ds = new DataSet();
try
{//@iPipelineID
SqlParameter[] Param = new SqlParameter[]
{
new SqlParameter("@iPortfolioID", Id)
};
dataAcess = new SqlDataAccess(clsConstant.DBCONSTRING);
if (dataAcess.Connection.State == ConnectionState.Closed)
{
dataAcess.Connection.Open();
}
ds = dataAcess.ExecuteDataSetQuery("GetPortFolioData", CommandType.StoredProcedure, Param);
dataAcess.Connection.Close();
return(ds);
}
catch
{
return(ds);
}
}
public DataSet GetDisbursementMonthWise(int disbursementID)
{
dataSet = new DataSet();
SqlDataAccess dataAcess = new SqlDataAccess("TA7511DBConnString");
dataSet = dataAcess.ExecuteDataSetQuery(clsConstant.SP_SELECT_DISBURSEMENT_DETAILS_MONTHWISE_EDIT, CommandType.StoredProcedure, new SqlParameter("@disbursementID", disbursementID));
return(dataSet);
}
public DataSet GetAllUser()
{
DataSet ds = new DataSet();
dataAccess = new SqlDataAccess("TA7511DBConnString");
ds = dataAccess.ExecuteDataSetQuery(clsConstant.SP_GET_ALL_USER, CommandType.StoredProcedure, null);
return(ds);
}
public DataSet GetPerformanceDetails()
{
dataAccess = new SqlDataAccess(clsConstant.DBCONSTRING);
if (dataAccess.Connection.State == ConnectionState.Closed)
{
dataAccess.Connection.Open();
}
ds = dataAccess.ExecuteDataSetQuery(clsConstant.SP_SELECT_PPMS_FLAG, CommandType.StoredProcedure, null);
return(ds);
}
public DataSet CheckExistingMonth(int loanID, int yearID)
{
dataSet = new DataSet();
SqlDataAccess dataAcess = new SqlDataAccess(clsConstant.DBCONSTRING);
SqlParameter[] param = new SqlParameter[] { new SqlParameter("@loanID", loanID),
new SqlParameter("@yearID", yearID) };
dataSet = dataAcess.ExecuteDataSetQuery(clsConstant.SP_SELECT_DISBURSEMENT_CHECK_MONTH, CommandType.StoredProcedure, param);
return(dataSet);
}
//----------------------------------------------------------------------
// Method: Search
// Author: Rabindra Kumar Das
// Description: Add new designation entry to the database
// Creation Date: 30-5-11
//
// Inputs: designationName - user designation, description - define the details of designation authorities
// Outputs: return a boolean value True if successfully executed else false
// Throws: Throw a proper exception message
// Revised By: Ashutosh Kushwaha
// Revision Date: 12/8/11
//---------------------------------------------------------------------
public DataSet CheckExisting(int loanID, int yearID)
{
SqlDataAccess dataAcess = new SqlDataAccess("TA7511DBConnString");
SqlParameter[] param = new SqlParameter[] { new SqlParameter("@loanID", loanID),
new SqlParameter("@yearID", yearID) };
dataSet = new DataSet();
dataSet = dataAcess.ExecuteDataSetQuery(clsConstant.SP_SELECT_CONTRACT_AWARD_CHECK, CommandType.StoredProcedure, param);
return(dataSet);
}
public void Search(string projectName, int loanNumber, DateTime year)
{
dataSet = new DataSet();
objDataAccess = new SqlDataAccess("TA7511DBConnString");
if (objDataAccess.Connection.State == ConnectionState.Closed)
{
objDataAccess.Connection.Open();
}
dataSet = objDataAccess.ExecuteDataSetQuery(clsConstant.SP_SELECT_DISBURSEMENT_DETAILS, CommandType.StoredProcedure, null);
}
public DataSet AdvertisementDetailsFilter(int AdvertisementID, string Sector, string endDate)
{
ds = new DataSet();
SqlDataAccess dataAcess = new SqlDataAccess("TA7511DBConnString");
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@firmid", AdvertisementID)
};
ds = dataAcess.ExecuteDataSetQuery(clsConstant.SP_SELECT_FIRM_DETAILS, CommandType.StoredProcedure, param);
return(ds);
}
public DataSet GetPerformance(int projectMasterID, int sectorID)
{
SqlParameter[] param = new SqlParameter[] { new SqlParameter("@loanID", projectMasterID),
new SqlParameter("@sectorID", sectorID) };
dataAccess = new SqlDataAccess(clsConstant.DBCONSTRING);
if (dataAccess.Connection.State == ConnectionState.Closed)
{
dataAccess.Connection.Open();
}
ds = dataAccess.ExecuteDataSetQuery(clsConstant.SP_SELECT_PERFORMANCE_FLAG_A, CommandType.StoredProcedure, param);
return(ds);
}
public DataSet FirmDetailsFilter(int status, int firmID, string startDate, string endDate)
{
ds = new DataSet();
SqlDataAccess dataAcess = new SqlDataAccess("TA7511DBConnString");
SqlParameter[] param = new SqlParameter[] { new SqlParameter("@status", status),
new SqlParameter("@firmid", firmID),
new SqlParameter("@startDate", startDate),
new SqlParameter("@endDate", startDate) };
ds = dataAcess.ExecuteDataSetQuery(clsConstant.SP_SELECT_FIRM_DETAILS, CommandType.StoredProcedure, param);
return(ds);
}
