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