public void SetUIFromSettings(SQLObjects.Global.RefreshMode mode) { // select db from setting if (mode == Global.RefreshMode.Application) { //names of servers List<ServerSetting> servers = Global.AppSettings.GetSettings(); cmbServer.DataContext = servers; if (Global.AppSettings.SelectedDB != null) { cmbServer.SelectedValue = Global.AppSettings.SelectedDB; } } //// no db selected in setting if (cmbServer.SelectedValue=="") return; else { Global.AppSettings.SelectedDB = cmbServer.SelectedValue.ToString(); } //if settings exist for db apply them Global.DBSetting = Global.ServSettings.GetDBSettings(Global.SelectedDB, true); }
public List <Sales_Monthly_Locaiton> getDetails_Sales_Monthly_Locaiton() { List <Sales_Monthly_Locaiton> sales_Monthly_Locaiton = new List <Sales_Monthly_Locaiton>(); string salesQuery = @"select FORMAT(PaidDate, 'yyyy-MM') as MonthDetails, LocationName, sum(amount) as PaidAmount from RecurringMaster inner join CandidateMaster on CandidateId = RefCandidateId inner join UserAccountDetails on UserId = RefSalesAssociate inner join LocationMaster on RefLocationId = LocationId where PaidDate is not null and RecurringMaster.PaymentStatus = 'Paid' group by FORMAT(PaidDate, 'yyyy-MM'), LocationName"; SQLObjects sqlObj = new SQLObjects(); sqlObj.sqlConnection = databaseConnectionSetting.getConn(); sqlObj.sqlDataAdapter = new System.Data.SqlClient.SqlDataAdapter(salesQuery, sqlObj.sqlConnection); sqlObj.dataTable = new System.Data.DataTable(); sqlObj.sqlDataAdapter.Fill(sqlObj.dataTable); foreach (DataRow row in sqlObj.dataTable.Rows) { Sales_Monthly_Locaiton model = new Sales_Monthly_Locaiton(); model.Amount = double.Parse(row["PaidAmount"].ToString()); model.Month = row["MonthDetails"].ToString(); model.Location = row["LocationName"].ToString(); sales_Monthly_Locaiton.Add(model); } return(sales_Monthly_Locaiton); }
// Overide the ProcessRecord method to process // the supplied user name and write out a // greeting to the user by calling the WriteObject // method. protected override void ProcessRecord() { IMessage mess = new MessageCmdLet(this); if (String.IsNullOrEmpty(this.FileJson) && ( String.IsNullOrEmpty(this.ServerName) && String.IsNullOrEmpty(this.ServerName) && String.IsNullOrEmpty(this.ServerName) && String.IsNullOrEmpty(this.ServerName) ) ) { mess.ShowParameterError(); return; } string path = AppDomain.CurrentDomain.BaseDirectory; string fileName = Path.Combine(path, this.FileJson); if (!File.Exists(fileName)) { mess.ShowParameterError(); return; } SQLObjects dbGen = new SQLObjects(); dbGen.Read(fileName); SQLGererator gen = new SQLGererator(mess); this.WriteVerbose(gen.ScriptDatabase(dbGen)); }
private void DeleteObject() { sql.Remove(SelectedObject); SelectedObject = new SQLExampleObject() { Name = "Select An Object" }; SQLObjects.ReplaceWith(sql.ReturnList()); }
public List <PlacementInfoModel> GetDetails(DateTime sdt, DateTime edt) { List <PlacementInfoModel> placementInfoModels = new List <PlacementInfoModel>(); SQLObjects sqlObj = new SQLObjects(); sqlObj.sqlConnection = databaseConnectionSetting.getConn(); //get podate wise string poDateWiseQuery = string.Format(@" select LocationName,CandidateName,PODate, iif(PODetails.JoiningDate is null, 'No Joining Date',convert(varchar,PODetails.JoiningDate,120)) as JoiningDate ,EnteryDate, SalesUser.FullName as SalesAssociateName, SalesUserLead.FullName as SalesTeamLeadName, SalesUserManager.FullName as SalesTeamManagerName, RecruiterName, TeamLeadName as MarketingTeamLead, PODetails.AddBy, POId from PODetails left join TeamDetails as SalesTeam on RefSaleId = SalesTeam.Member left join UserAccountDetails as SalesUser on SalesUser.UserId = SalesTeam.Member left join UserAccountDetails as SalesUserLead on SalesUserLead.UserId = SalesTeam.TeamLead left join UserAccountDetails as SalesUserManager on SalesUserManager.UserId = SalesTeam.TeamManager left join UserAccountDetails as RecuriterUser on RecuriterUser.RocketName = RecruiterName inner join LocationMaster on LocationId = RecuriterUser.RefLocationId left join UserAccountDetails as InterviewSupportUser on InterviewSupportUser.RocketName = PODetails.InterviewSupport left join UserAccountDetails as TrainerUser on TrainerUser.RocketName = PODetails.TrainerName where PODate between '{0}' and '{1}'", sdt.ToString("yyyy-MM-dd"), edt.ToString("yyyy-MM-dd")); sqlObj.sqlDataAdapter = new System.Data.SqlClient.SqlDataAdapter(poDateWiseQuery, sqlObj.sqlConnection); sqlObj.dataTable = new System.Data.DataTable(); sqlObj.sqlDataAdapter.Fill(sqlObj.dataTable); foreach (DataRow item in sqlObj.dataTable.Rows) { PlacementInfoModel model = new PlacementInfoModel() { EnterBy = item["AddBy"].ToString(), EntryDate = DateTime.Parse(item["EnteryDate"].ToString()), LocationName = item["LocationName"].ToString(), PODate = DateTime.Parse(item["PODate"].ToString()), POId = int.Parse(item["POId"].ToString()) }; if (!item["JoiningDate"].ToString().Contains("No")) { model.JoiningDate = DateTime.Parse(item["JoiningDate"].ToString()); } model.MarketingTeamDetails = string.Format(@"{0}<br>{1}", item["RecruiterName"].ToString(), item["MarketingTeamLead"].ToString()); model.SalesTeamDetails = string.Format(@"{0}<br>{1}<br>{2}", item["SalesAssociateName"].ToString(), item["SalesTeamLeadName"].ToString(), item["SalesTeamManagerName"].ToString()); placementInfoModels.Add(model); } return(placementInfoModels); //get joining date wise }
private int GetSubmissions(int cid) { /**/ string countGetQuery = @" select count(*) as dayscount from SubmissionDetails inner join CandidateAssign on RefAssignedId = AssignedId inner join CandidateMarketingDetails on RefMarketingId = MarketingId where refcandidateid = " + cid.ToString(); SQLObjects sqlObj = new SQLObjects(); sqlObj.sqlConnection = databaseConnectionSetting.getConn(); sqlObj.sqlDataAdapter = new System.Data.SqlClient.SqlDataAdapter(countGetQuery, sqlObj.sqlConnection); sqlObj.dataTable = new DataTable(); if (sqlObj.dataTable.Rows.Count > 0) { return(int.Parse(sqlObj.dataTable.Rows[0]["dayscount"].ToString())); } return(0); } private int GetInterviews(int cid) { /**/ string countGetQuery = @" select count(*) as dayscount from SubmissionDetails inner join CandidateAssign on RefAssignedId = AssignedId inner join CandidateMarketingDetails on RefMarketingId = MarketingId inner join InterviewDetails on RefSumissionId = SubmissionId where refcandidateid = " + cid.ToString(); SQLObjects sqlObj = new SQLObjects(); sqlObj.sqlConnection = databaseConnectionSetting.getConn(); sqlObj.sqlDataAdapter = new System.Data.SqlClient.SqlDataAdapter(countGetQuery, sqlObj.sqlConnection); sqlObj.dataTable = new DataTable(); if (sqlObj.dataTable.Rows.Count > 0) { return(int.Parse(sqlObj.dataTable.Rows[0]["dayscount"].ToString())); } return(0); }
private int GetRUCCount(int cid) { string countGetQuery = @"select datediff(day,Date,TaskDate) as dayscount from CandidateTechnicalExpertDetails inner join CandidateMaster on CandidateId = RefAssignedCandidateId inner join TaskManageMaster on RefCTId = CTId where RefTaskCatId = 2 and TaskStatus = 'Completed' and TotalMin > 10 and CandidateId =" + cid.ToString(); SQLObjects sqlObj = new SQLObjects(); sqlObj.sqlConnection = databaseConnectionSetting.getConn(); sqlObj.sqlDataAdapter = new System.Data.SqlClient.SqlDataAdapter(countGetQuery, sqlObj.sqlConnection); sqlObj.dataTable = new DataTable(); if (sqlObj.dataTable.Rows.Count > 0) { return(int.Parse(sqlObj.dataTable.Rows[0]["dayscount"].ToString())); } return(0); }
public string GetDetails() { list = new List <MonthsOrederSalesModel>(); try { DateTime startDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); DateTime endDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); endDate = endDate.AddMonths(1).AddDays(-1); SQLObjects sqlObj = new SQLObjects(); sqlObj.sqlConnection = databaseConnectionSetting.getConn(); string salesRevenue = string.Format(@" select CandidateName,CandidateId,FullName,TechTitle,PaidDate,PaidAmount from CandidateMaster inner join UserAccountDetails on RefSalesAssociate = UserAccountDetails.UserId inner join TechnologyMaster on TechId = TechnologyId inner join RecurringMaster on CandidateId = RefCandidateId where PaidDate between '{0}' and '{1}'", startDate.ToString("yyyy-MM-dd"), endDate.ToString("yyyy-MM-dd")); sqlObj.sqlDataAdapter = new System.Data.SqlClient.SqlDataAdapter(salesRevenue, sqlObj.sqlConnection); sqlObj.dataTable = new System.Data.DataTable(); sqlObj.sqlDataAdapter.Fill(sqlObj.dataTable); sqlObj.sqlConnection.Close(); foreach (DataRow item in sqlObj.dataTable.Rows) { MonthsOrederSalesModel model = new MonthsOrederSalesModel(); model.CandidateId = int.Parse(item["CandidateId"].ToString()); model.CandidateName = item["CandidateName"].ToString(); model.Date = DateTime.Parse(item["PaidDate"].ToString()); model.PaidAmount = int.Parse(item["PaidAmount"].ToString()); model.Technology = item["TechTitle"].ToString(); model.SalesAssociateName = item["FullName"].ToString(); list.Add(model); } return("0"); } catch (Exception ex) { return(ex.Message); } }
public List <CandidateTimeLineModel> GetList(DateTime sdt, DateTime edt) { List <CandidateTimeLineModel> candidateTimeLines = new List <CandidateTimeLineModel>(); DateTime todayDate = sdt; DateTime lastDate = edt;// DateTime.Now; //lastDate = lastDate.AddMonths(1).AddDays(-1); string query = string.Format(@"select CandidateId from CandidateMaster where Date between '{0}' and '{1}'", todayDate.ToString("yyyy-MM-dd"), lastDate.ToString("yyyy-MM-dd")); SQLObjects sqlObj = new SQLObjects(); sqlObj.sqlDataAdapter = new System.Data.SqlClient.SqlDataAdapter(query, sqlObj.sqlConnection); sqlObj.dataTable = new System.Data.DataTable(); sqlObj.sqlDataAdapter.Fill(sqlObj.dataTable); sqlObj.sqlConnection.Close(); foreach (DataRow item in sqlObj.dataTable.Rows) { this.GetData(int.Parse(item["CandidateId"].ToString())); candidateTimeLines.Add(timeLineModel); } return(candidateTimeLines); }
private void RefreshList() { sql.GenerateSampleList(); SQLObjects.ReplaceWith(sql.ReturnList()); }
public CandidateDetailBoardLogic() { sqlObj = new SQLObjects(); }
public List <CandidateMarketingModel> getData(DateTime stDate, DateTime endDate) { List <CandidateMarketingModel> candidates = new List <CandidateMarketingModel>(); SQLObjects sqlObj = new SQLObjects(); //set up sql object sqlObj.sqlConnection = databaseConnectionSetting.getConn(); //getting the Candidate Details #region Get Candidate Details string candidateQuery = string.Format(@" select CandidateId, MarketingId,CandidateMaster.CandidateName, Recruiter.FullName as RecruiterName, MarketingTeamLead.FullName as TeamLeadName, MarketingTeamManager.FullName as TeamManagerName, CandidateMaster.MarketingStartDate, iif(PODetails.PODate is NULL,'No PO',convert(varchar,PODetails.PODate,23)) as PODate, iif(PODetails.POId is NULL,'No PO',convert(varchar,PODetails.POId,1)) as POId from CandidateMaster inner join CandidateMarketingDetails on CandidateId = RefCandidateId inner join CandidateAssign on refMarketingId = MarketingId inner join TeamDetails on TeamId = RefTeamId inner join UserAccountDetails as Recruiter on TeamDetails.Member = Recruiter.UserId inner join UserAccountDetails as MarketingTeamLead on TeamDetails.TeamLead = MarketingTeamLead.UserId inner join UserAccountDetails as MarketingTeamManager on TeamDetails.TeamManager = MarketingTeamManager.UserId left join PODetails on PODetails.CandidateName = CandidateMaster.CandidateName where CandidateAssign.IsActive = 1 and CandidateMaster.MarketingStartDate between '{0}' and '{1}' ", stDate.ToString("yyyy-MM-dd"), endDate.ToString("yyyy-MM-dd")); sqlObj.sqlDataAdapter = new System.Data.SqlClient.SqlDataAdapter(candidateQuery, sqlObj.sqlConnection); sqlObj.dataTable = new System.Data.DataTable(); sqlObj.sqlDataAdapter.Fill(sqlObj.dataTable); sqlObj.sqlConnection.Close(); foreach (DataRow row in sqlObj.dataTable.Rows) { CandidateMarketingModel candidate = new CandidateMarketingModel(); candidate.CandidateId = int.Parse(row["CandidateId"].ToString()); candidate.MarketingId = int.Parse(row["MarketingId"].ToString()); candidate.CandidateName = row["CandidateName"].ToString(); candidate.KPIAccuracy = 0.0; candidate.MarketingStartDate = DateTime.Parse(row["MarketingStartDate"].ToString()); candidate.MarketingTeamLeadName = row["TeamLeadName"].ToString(); candidate.MarketingTeamManagerName = row["TeamManagerName"].ToString(); if (row["PODate"].ToString() != "No PO") { candidate.PODetailsId = int.Parse(row["POId"].ToString()); candidate.PODate = DateTime.Parse(row["PODate"].ToString()); DateTime podate = (DateTime)candidate.PODate; candidate.TotalDaysPOGet = podate.Subtract(candidate.MarketingStartDate).Days; } candidate.RecruiterName = row["RecruiterName"].ToString(); candidate.TotalDaysResumeProcessDone = GetRUCCount(candidate.CandidateId); candidate.TotalInterviews = GetSubmissions(candidate.CandidateId); candidate.TotalInterviewSupports = GetInterviewSupports(candidate.CandidateId); candidate.TotalSubmissions = GetSubmissions(candidate.CandidateId); candidates.Add(candidate); } #endregion return(candidates); }
public string GetDetails() { infoBox = new InfoBoxModel(); try { SQLObjects sqlObj = new SQLObjects(); sqlObj.sqlConnection = databaseConnectionSetting.getConn(); DateTime todayDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); DateTime lastDate = DateTime.Now; lastDate = lastDate.AddMonths(1).AddDays(-1); #region Current Total Revenue string currentRevenueQuery = @"select sum(Amount) as CurrentAmount from RecurringMaster where PaymentStatus = 'Paid'"; sqlObj.sqlDataAdapter = new System.Data.SqlClient.SqlDataAdapter(currentRevenueQuery, sqlObj.sqlConnection); sqlObj.dataTable = new System.Data.DataTable(); sqlObj.sqlDataAdapter.Fill(sqlObj.dataTable); sqlObj.sqlConnection.Close(); string currentRevenue = sqlObj.dataTable.Rows[0]["CurrentAmount"].ToString().Split('.')[0]; infoBox.TotalRevenue = int.Parse(currentRevenue); #endregion #region todays Revenue Total string todaysRevenueQuery = string.Format(@"select sum(Amount) as TodayRevenue from RecurringMaster where PaidDate = '{0}'", todayDate.ToString("yyyy-MM-dd")); sqlObj.sqlDataAdapter = new System.Data.SqlClient.SqlDataAdapter(todaysRevenueQuery, sqlObj.sqlConnection); sqlObj.dataTable = new System.Data.DataTable(); sqlObj.sqlDataAdapter.Fill(sqlObj.dataTable); sqlObj.sqlConnection.Close(); string todayRevenue = sqlObj.dataTable.Rows[0]["TodayRevenue"].ToString().Split('.')[0]; infoBox.TodaysRevenue = int.Parse(todayRevenue); #endregion #region Current Month Revenue Total string queryCurrentMonthRevenue = string.Format(@"select sum(Amount) as CurrentMonthRevenue from RecurringMaster where FORMAT(PaidDate, 'MMM-yyyy') = '{0}' and PaymentStatus = 'Paid'", todayDate.Date.ToString("MMM-yyyy")); sqlObj.sqlDataAdapter = new SqlDataAdapter(queryCurrentMonthRevenue, sqlObj.sqlConnection); sqlObj.dataTable = new DataTable(); sqlObj.sqlDataAdapter.Fill(sqlObj.dataTable); if (sqlObj.dataTable.Rows.Count == 1) { string CurrentMonthRevenue = sqlObj.dataTable.Rows[0]["CurrentMonthRevenue"].ToString().Split('.')[0]; infoBox.CurrentMonthRevenue = int.Parse(CurrentMonthRevenue); } if (sqlObj.sqlConnection.State == ConnectionState.Open) { sqlObj.sqlConnection.Close(); } #endregion #region Today's Candidate Count string totalCandidateQuery = string.Format(@"select count(*) as todayCount from CandidateMaster where CandidateStatus in ('Resume Preparation', 'Resume Verification','In Marketing','In Training','Not Responding To Resume Team','RUC Done','RUC Pending','Sales')", DateTime.Now.Date.ToString("yyyy-MM-dd")); sqlObj.sqlDataAdapter = new SqlDataAdapter(totalCandidateQuery, sqlObj.sqlConnection); sqlObj.dataTable = new DataTable(); sqlObj.sqlDataAdapter.Fill(sqlObj.dataTable); sqlObj.sqlConnection.Close(); if (sqlObj.dataTable.Rows.Count == 1) { string todaysCount = sqlObj.dataTable.Rows[0]["todayCount"].ToString().Split('.')[0]; infoBox.TotalCandidate = int.Parse(todaysCount); } #endregion #region today's placement string todaysPlacementsQuery = string.Format(@"select count(*) as todayPlacement from PODetails where PODate = '{0}'", todayDate.ToString("yyyy-MM-dd")); sqlObj.sqlDataAdapter = new SqlDataAdapter(todaysPlacementsQuery, sqlObj.sqlConnection); sqlObj.dataTable = new DataTable(); sqlObj.sqlDataAdapter.Fill(sqlObj.dataTable); sqlObj.sqlConnection.Close(); if (sqlObj.dataTable.Rows.Count == 1) { string todaysPlacement = sqlObj.dataTable.Rows[0]["todayPlacement"].ToString().Split('.')[0]; infoBox.TodaysPlacements = int.Parse(todaysPlacement); } #endregion #region current Month Placement string currentMonthPlacementQuery = string.Format(@"select count(*) as currentMonthPlacements from PODetails where PODate between '{0}' and '{1}'", todayDate.ToString("yyyy-MM-dd"), lastDate.ToString("yyyy-MM-dd")); sqlObj.sqlDataAdapter = new SqlDataAdapter(currentMonthPlacementQuery, sqlObj.sqlConnection); sqlObj.dataTable = new DataTable(); sqlObj.sqlDataAdapter.Fill(sqlObj.dataTable); sqlObj.sqlConnection.Close(); if (sqlObj.dataTable.Rows.Count == 1) { string currentmMonthPlacement = sqlObj.dataTable.Rows[0]["currentMonthPlacements"].ToString().Split('.')[0]; infoBox.CurrentMonthPlacement = int.Parse(currentmMonthPlacement); } #endregion return(null); } catch (Exception ex) { return("Error:" + ex.Message); } }
public string GetData(int id) { timeLineModel = new CandidateTimeLineModel(); timeLineModel.MarketingStartDate = new DateTime(1, 1, 1); timeLineModel.RegistrationDate = new DateTime(1, 1, 1); timeLineModel.ResumeCallDate = new DateTime(1, 1, 1); timeLineModel.ResumePreparedDate = new DateTime(1, 1, 1); timeLineModel.ResumeVerifiedDate = new DateTime(1, 1, 1); timeLineModel.ResumeUnderstandingDate = new DateTime(1, 1, 1); timeLineModel.MarketingStartDate = new DateTime(1, 1, 1); try { SQLObjects sqlObj = new SQLObjects(); #region Registration Date string regDateQuery = string.Format(@"select CandidateName, CandidateId,date,FullName,TechTitle,CandidateStatus from CandidateMaster inner join UserAccountDetails on UserId = RefSalesAssociate inner join TechnologyMaster on TechnologyId = TechId where CandidateId = {0}", id); sqlObj.sqlDataAdapter = new System.Data.SqlClient.SqlDataAdapter(regDateQuery, sqlObj.sqlConnection); sqlObj.dataTable = new System.Data.DataTable(); sqlObj.sqlDataAdapter.Fill(sqlObj.dataTable); timeLineModel.CandidateName = sqlObj.dataTable.Rows[0]["CandidateName"].ToString(); timeLineModel.Technology = sqlObj.dataTable.Rows[0]["TechTitle"].ToString(); timeLineModel.SalesAssociates = sqlObj.dataTable.Rows[0]["FullName"].ToString(); timeLineModel.CurrentStatus = sqlObj.dataTable.Rows[0]["CandidateStatus"].ToString(); timeLineModel.RegistrationDate = DateTime.Parse(sqlObj.dataTable.Rows[0]["Date"].ToString()); #endregion #region Resume Call Done string resumeCallDoneDateQuery = string.Format(@"select * from CandidateTimeLine where RefCandidateId = {0} and Status = 'Resume Call Done'", id); sqlObj.sqlDataAdapter = new System.Data.SqlClient.SqlDataAdapter(resumeCallDoneDateQuery, sqlObj.sqlConnection); sqlObj.dataTable = new System.Data.DataTable(); sqlObj.sqlDataAdapter.Fill(sqlObj.dataTable); if (sqlObj.dataTable.Rows.Count == 1) { timeLineModel.ResumeCallDate = DateTime.Parse(sqlObj.dataTable.Rows[0]["Date"].ToString()); } #endregion #region Resume Prepared Date string resumePreparedDateQuery = string.Format(@"select * from CandidateTimeLine where RefCandidateId = {0} and Status = 'Resume Preparation'", id); sqlObj.sqlDataAdapter = new System.Data.SqlClient.SqlDataAdapter(resumePreparedDateQuery, sqlObj.sqlConnection); sqlObj.dataTable = new System.Data.DataTable(); sqlObj.sqlDataAdapter.Fill(sqlObj.dataTable); if (sqlObj.dataTable.Rows.Count == 1) { timeLineModel.ResumePreparedDate = DateTime.Parse(sqlObj.dataTable.Rows[0]["Date"].ToString()); } #endregion #region Resume Verified Date string resumeVerifiedDateQuery = string.Format(@" select Date from CandidateMaster where CandidateId = {0}", id); #endregion #region Resume Understanding Date string resumeUnderstandingDateQuery = string.Format(@"select TaskDate,FullName from CandidateTechnicalExpertDetails inner join TaskManageMaster on RefCTId = CTId inner join UserAccountDetails on UserId = RefAssignedExpertId where RefAssignedCandidateId = {0} and RefTaskCatId = 2 and TaskStatus = 'Completed'", id); sqlObj.sqlDataAdapter = new System.Data.SqlClient.SqlDataAdapter(resumeUnderstandingDateQuery, sqlObj.sqlConnection); sqlObj.dataTable = new System.Data.DataTable(); sqlObj.sqlDataAdapter.Fill(sqlObj.dataTable); if (sqlObj.dataTable.Rows.Count > 0) { timeLineModel.ResumeUnderstandingDate = DateTime.Parse(sqlObj.dataTable.Rows[0]["TaskDate"].ToString()); timeLineModel.ResumeUnderstandingCompletedBy = sqlObj.dataTable.Rows[0]["FullName"].ToString(); } #endregion #region Marketing Start Date string marketingStartDateQuery = string.Format(@" select Date from CandidateMaster where CandidateId = {0}", id); #endregion #region Training Date string trainingEndDateQuery = string.Format(@"select BatchEndDate,BatchStartDate,FullName from CandidateTechnicalExpertDetails inner join UserAccountDetails on UserId = RefAssignedExpertId inner join CandidateBatchDetails on RefBatchId = BatchId where RefAssignedCandidateId = {0}", id); sqlObj.sqlDataAdapter = new System.Data.SqlClient.SqlDataAdapter(trainingEndDateQuery, sqlObj.sqlConnection); sqlObj.dataTable = new System.Data.DataTable(); sqlObj.sqlDataAdapter.Fill(sqlObj.dataTable); if (sqlObj.dataTable.Rows.Count > 0) { timeLineModel.TrainingEndDate = DateTime.Parse(sqlObj.dataTable.Rows[0]["BatchEndDate"].ToString()); timeLineModel.TrainerName = sqlObj.dataTable.Rows[0]["FullName"].ToString(); } #endregion return("0"); } catch (Exception ex) { return(ex.Message); } }