public static int InsertPorjectStatus(int projectID, char deliverablesAndResultsStatus, string deliverablesAndResultsComments, char scheduleStatus,
string scheduleComment, char capacityResourceStatus, string capacityResourceComment, char scopeStatus, string scopeComment, char clientSatisfactionStatus,
string clientSatisfactionComment, char issuesAndRisksStatus, string issuesAndRisksComment, char useOfTestcontrolStatus, string useOfTestcontrolComment,
char employeeSatisfactionStatus, string employeeSatisfactionComment, char knownOpportunityStatus, string knownOpportunityComment, char clientContactStatus, string clientContactComment)
{
List <SqlParameter> paramList = new List <SqlParameter>();
string query = "EXECUTE dbo.InsertProjectStatus @projectID, @deliverablesAndResultsStatus, @deliverablesAndResultsComment, @schedueStatus,"
+ "@scheduleComment, @capacityResourceStatus, @capacityResourceComment, @scopeStatus, @scopeComment, @clientSatisfactionStatus,"
+ "@clientSatisfactionComment, @issuesAndRisksStatus, @issuesAndRisksComment, @useOfTestControlStatus, @useOfTestControlComment,"
+ "@employeeSatisfactionStatus, @employeeSatisfactionComment, @knownOpportunityStatus, @knownOpportunityComment, @clientContactStatus, @clientContactComment";
#region Parameters
paramList.Add(new SqlParameter("@projectID", SqlDbType.Int));
paramList[0].Value = projectID;
paramList.Add(new SqlParameter("@deliverablesAndResultsStatus", SqlDbType.VarChar, 1));
paramList[1].Value = deliverablesAndResultsStatus;
paramList.Add(new SqlParameter("@deliverablesAndResultsComment", SqlDbType.VarChar, -1));
paramList[2].Value = deliverablesAndResultsComments;
paramList.Add(new SqlParameter("@schedueStatus", SqlDbType.VarChar, 1));
paramList[3].Value = scheduleStatus;
paramList.Add(new SqlParameter("@scheduleComment", SqlDbType.VarChar, -1));
paramList[4].Value = scheduleComment;
paramList.Add(new SqlParameter("@capacityResourceStatus", SqlDbType.VarChar, 1));
paramList[5].Value = capacityResourceStatus;
paramList.Add(new SqlParameter("@capacityResourceComment", SqlDbType.VarChar, -1));
paramList[6].Value = capacityResourceComment;
paramList.Add(new SqlParameter("@scopeStatus", SqlDbType.VarChar, 1));
paramList[7].Value = scopeStatus;
paramList.Add(new SqlParameter("@scopeComment", SqlDbType.VarChar, -1));
paramList[8].Value = scopeComment;
paramList.Add(new SqlParameter("@clientSatisfactionStatus", SqlDbType.VarChar, 1));
paramList[9].Value = clientSatisfactionStatus;
paramList.Add(new SqlParameter("@clientSatisfactionComment", SqlDbType.VarChar, -1));
paramList[10].Value = clientSatisfactionComment;
paramList.Add(new SqlParameter("@issuesAndRisksStatus", SqlDbType.VarChar, 1));
paramList[11].Value = issuesAndRisksStatus;
paramList.Add(new SqlParameter("@issuesAndRisksComment", SqlDbType.VarChar, -1));
paramList[12].Value = issuesAndRisksComment;
paramList.Add(new SqlParameter("@useOfTestControlStatus", SqlDbType.VarChar, 1));
paramList[13].Value = useOfTestcontrolStatus;
paramList.Add(new SqlParameter("@useOfTestControlComment", SqlDbType.VarChar, -1));
paramList[14].Value = useOfTestcontrolComment;
paramList.Add(new SqlParameter("@employeeSatisfactionStatus", SqlDbType.VarChar, 1));
paramList[15].Value = employeeSatisfactionStatus;
paramList.Add(new SqlParameter("@employeeSatisfactionComment", SqlDbType.VarChar, -1));
paramList[16].Value = employeeSatisfactionComment;
paramList.Add(new SqlParameter("@knownOpportunityStatus", SqlDbType.VarChar, 1));
paramList[17].Value = knownOpportunityStatus;
paramList.Add(new SqlParameter("@knownOpportunityComment", SqlDbType.VarChar, -1));
paramList[18].Value = knownOpportunityComment;
paramList.Add(new SqlParameter("@clientContactStatus", SqlDbType.VarChar, 1));
paramList[19].Value = clientContactStatus;
paramList.Add(new SqlParameter("@clientContactComment", SqlDbType.VarChar, -1));
paramList[20].Value = clientContactComment;
#endregion
return(DataBaseGenerics.InsertData(query, paramList, CommandType.Text));
}
public static int InsertPerson(string firstName, string lastName)
{
List <SqlParameter> paramList = new List <SqlParameter>();
paramList.Add(new SqlParameter("@firstName", SqlDbType.NVarChar, 50));
paramList[0].Value = firstName;
paramList.Add(new SqlParameter("@lastName", SqlDbType.NVarChar, 50));
paramList[1].Value = lastName;
return(DataBaseGenerics.InsertData("EXECUTE InsertPerson @firstName, @lastName", paramList, CommandType.Text));
}
public static int InsertClient(string clientName, string clientAddress, string clientContactNumber)
{
List <SqlParameter> paramList = new List <SqlParameter>();
paramList.Add(new SqlParameter("@clientName", SqlDbType.NVarChar, 50));
paramList[0].Value = clientName;
paramList.Add(new SqlParameter("@clientAddress", SqlDbType.NVarChar, 100));
paramList[1].Value = clientAddress;
paramList.Add(new SqlParameter("@clientContactNumber", SqlDbType.NVarChar, 30));
paramList[2].Value = clientContactNumber;
return(DataBaseGenerics.InsertData("EXECUTE InsertClient @clientName, @clientAddress, @clientContactNumber", paramList, CommandType.Text));
}
public static int InsertProject(string projectName, string projectDescription, DateTime startDate, DateTime endDate, DateTime revisedDate,
int sogetiPractitionerID, int accountManagerID, int deliveryManagerID, int administratorID, int clientID, int leadID,
char commercialTerms, char reviewFrequency, char sogetiServiceLine)
{
List <SqlParameter> paramList = new List <SqlParameter>();
paramList.Add(new SqlParameter("@projectName", SqlDbType.NVarChar, 50));
paramList[0].Value = projectName;
paramList.Add(new SqlParameter("@projectDescription", SqlDbType.NVarChar, 100));
paramList[1].Value = projectDescription;
paramList.Add(new SqlParameter("@startDate", SqlDbType.SmallDateTime));
paramList[2].Value = startDate;
paramList.Add(new SqlParameter("@endDate", SqlDbType.SmallDateTime));
paramList[3].Value = endDate;
paramList.Add(new SqlParameter("@revisedDate", SqlDbType.SmallDateTime));
paramList[4].Value = revisedDate;
paramList.Add(new SqlParameter("@sogetiPractitioner", SqlDbType.Int));
paramList[5].Value = sogetiPractitionerID;
paramList.Add(new SqlParameter("@accountManager", SqlDbType.Int));
paramList[6].Value = accountManagerID;
paramList.Add(new SqlParameter("@deliveryManager", SqlDbType.Int));
paramList[7].Value = deliveryManagerID;
paramList.Add(new SqlParameter("@admin", SqlDbType.Int));
paramList[8].Value = administratorID;
paramList.Add(new SqlParameter("@clientID", SqlDbType.Int));
paramList[9].Value = clientID;
paramList.Add(new SqlParameter("@prjLead", SqlDbType.Int));
paramList[10].Value = leadID;
paramList.Add(new SqlParameter("@commTerms", SqlDbType.VarChar, 1));
paramList[11].Value = commercialTerms;
paramList.Add(new SqlParameter("@reviewFreq", SqlDbType.VarChar, 1));
paramList[12].Value = reviewFrequency;
paramList.Add(new SqlParameter("@sogServiceLine", SqlDbType.VarChar, 1));
paramList[13].Value = sogetiServiceLine;
return(DataBaseGenerics.InsertData("InsertProject @projectName, @projectDescription, @startDate, @endDate, @revisedDate, @sogetiPractitioner, @accountManager, @deliveryManager, @admin, @clientID, @prjLead, @commTerms, @reviewFreq, @sogServiceLine", paramList, CommandType.Text));
}
