public List <ExportClass> ExportMonthlyRecordList(string month_year) { EngagementSummary ObjSummary = new EngagementSummary(); ObjSummary.ExportMonthlyDatalist = new List <ExportClass>(); string[] values = new string[3]; int month = 0; int year = 0; if (month_year.Contains("_")) { values = month_year.Split('_'); month = DateTime.ParseExact(values[1], "MMMM", CultureInfo.CurrentCulture).Month; year = Convert.ToInt32(values[2]); } using (SqlConnection con = new SqlConnection(str)) { SqlCommand cmd = null; cmd = new SqlCommand(constants.SPGetMontlyRecord, con); cmd.Parameters.Add("ExistExtendComplete", SqlDbType.VarChar).Value = values[0]; cmd.Parameters.Add("Month", SqlDbType.Int).Value = month; cmd.Parameters.Add("year", SqlDbType.Int).Value = year; cmd.CommandType = CommandType.StoredProcedure; try { con.Open(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { ObjSummary.ExportMonthlyDatalist.Add(new ExportClass { SOWNo = Convert.ToString(dr[constants.SOWNo]), SignedStatus = Convert.ToString(dr[constants.SignedStatus]), JoiningStatus = Convert.ToString(dr[constants.JoiningStatus]), SOWDate = Convert.ToDateTime(dr[constants.SOWDate]), ClientName = Convert.ToString(dr[constants.ClientName]), ProjectName = Convert.ToString(dr[constants.ProjectName]), ResourceName = Convert.ToString(dr[constants.ResourceName]), WorkLocation = Convert.ToString(dr[constants.WorkLocation]), BussinessUnit = Convert.ToString(dr[constants.BussinessUnit]), Designation = Convert.ToString(dr[constants.Designation]), ReportingTime = Convert.ToString(dr[constants.ReportingTime]), RecruiterName = Convert.ToString(dr[constants.RecruiterName]), HardwareRequirement = Convert.ToString(dr[constants.HardwareRequirement]), SoftwareRequirement = Convert.ToString(dr[constants.SoftwareRequirement]), Remarks = Convert.ToString(dr[constants.Remarks]), AssignmentStartDate = Convert.ToDateTime(dr[constants.AssignmentStartDate]), TentativeEndDate = Convert.ToDateTime(dr[constants.AssignmentEndDate]), Technology = Convert.ToString(dr[constants.Technology]), AttachFile1 = Convert.ToString(dr[constants.File1]), EstimatedRateValue = Convert.ToString(dr[constants.EstimatedRateValue]), FixedBidOrTM = Convert.ToString(dr[constants.FixedBidTM]), PartnerName = Convert.ToString(dr[constants.PartnerName]), ReportingManager = Convert.ToString(dr[constants.ReportingManager]), GuestAccomodation = Convert.ToBoolean(dr[constants.GuestAccomodation]), FinanceEmailAddress = Convert.ToString(dr[constants.FinanceEmailAddress]), OnBoardEmailAddress = Convert.ToString(dr[constants.OnBoardEmailAddress]) }); } } catch (Exception ex) { throw new Exception(ex.Message + " in GetMonthlyRecordList()"); } } return(ObjSummary.ExportMonthlyDatalist); }
public List <ExportClass> ExportExistingEngagementList() { EngagementSummary ObjSummary = new EngagementSummary(); ObjSummary.ExportExistingEngagementList = new List <ExportClass>(); using (SqlConnection con = new SqlConnection(str)) { SqlCommand cmd = null; cmd = new SqlCommand(constants.SPGetListOfExistingEngagements, con); cmd.CommandType = CommandType.StoredProcedure; try { con.Open(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { ObjSummary.ExportExistingEngagementList.Add(new ExportClass { SOWNo = Convert.ToString(dr[constants.SOWNo]), SignedStatus = Convert.ToString(dr[constants.SignedStatus]), JoiningStatus = Convert.ToString(dr[constants.JoiningStatus]), SOWDate = Convert.ToDateTime(dr[constants.SOWDate]), ClientName = Convert.ToString(dr[constants.ClientName]), ProjectName = Convert.ToString(dr[constants.ProjectName]), ResourceName = Convert.ToString(dr[constants.ResourceName]), WorkLocation = Convert.ToString(dr[constants.WorkLocation]), BussinessUnit = Convert.ToString(dr[constants.BussinessUnit]), Designation = Convert.ToString(dr[constants.Designation]), ReportingTime = Convert.ToString(dr[constants.ReportingTime]), RecruiterName = Convert.ToString(dr[constants.RecruiterName]), HardwareRequirement = Convert.ToString(dr[constants.HardwareRequirement]), SoftwareRequirement = Convert.ToString(dr[constants.SoftwareRequirement]), Remarks = Convert.ToString(dr[constants.Remarks]), AssignmentStartDate = Convert.ToDateTime(dr[constants.AssignmentStartDate]), TentativeEndDate = Convert.ToDateTime(dr[constants.AssignmentEndDate]), Technology = Convert.ToString(dr[constants.Technology]), AttachFile1 = Convert.ToString(dr[constants.File1]), EstimatedRateValue = Convert.ToString(dr[constants.EstimatedRateValue]), FixedBidOrTM = Convert.ToString(dr[constants.FixedBidTM]), PartnerName = Convert.ToString(dr[constants.PartnerName]), ReportingManager = Convert.ToString(dr[constants.ReportingManager]), GuestAccomodation = Convert.ToBoolean(dr[constants.GuestAccomodation]), FinanceEmailAddress = Convert.ToString(dr[constants.FinanceEmailAddress]), OnBoardEmailAddress = Convert.ToString(dr[constants.OnBoardEmailAddress]) }); } } catch (Exception ex) { throw new Exception(ex.Message + " in ExportExistingEngagementList()"); } } return(ObjSummary.ExportExistingEngagementList); }
public EngagementSummary GetEngagementSummary() { EngagementSummary ObjSummary = new EngagementSummary(); ObjSummary.CompletedEngagements = new Months(); using (SqlConnection con = new SqlConnection(str)) { SqlCommand cmd = null; cmd = new SqlCommand(constants.SpGetEngagementCompleted, con); cmd.CommandType = CommandType.StoredProcedure; try { con.Open(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { var property = ObjSummary.CompletedEngagements.GetType().GetProperty(dr[0].ToString()); property.SetValue(ObjSummary.CompletedEngagements, Convert.ToInt32(dr[1])); } } catch (Exception ex) { throw new Exception(ex.Message + " in GetListAllrecord()"); } } ObjSummary.ExtentedEngagements = new Months(); using (SqlConnection con = new SqlConnection(str)) { SqlCommand cmd = null; cmd = new SqlCommand(constants.SpGetEngagementExtended, con); cmd.CommandType = CommandType.StoredProcedure; try { con.Open(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { var property = ObjSummary.ExtentedEngagements.GetType().GetProperty(dr[0].ToString()); property.SetValue(ObjSummary.ExtentedEngagements, Convert.ToInt32(dr[1])); } } catch (Exception ex) { throw new Exception(ex.Message + " in GetListAllrecord()"); } } ObjSummary.ExistingEngagements = new Months(); using (SqlConnection con = new SqlConnection(str)) { SqlCommand cmd = null; cmd = new SqlCommand(constants.SpGetEngagementStarted, con); cmd.CommandType = CommandType.StoredProcedure; try { con.Open(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { var property = ObjSummary.ExistingEngagements.GetType().GetProperty(dr[0].ToString()); property.SetValue(ObjSummary.ExistingEngagements, Convert.ToInt32(dr[1])); } } catch (Exception ex) { throw new Exception(ex.Message + " in GetListAllrecord()"); } } return(ObjSummary); }