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