public int ChangeClientActions(ClientRegistrationEntity clientinfo, FeedbackEntity feedbackEntity, char Operation)
{
Hashtable hashtable = new Hashtable();
if (Operation == 'S')
{
hashtable.Add("@ClientStatus", clientinfo.Status);
hashtable.Add("@VerifiedBy", DBNull.Value);
hashtable.Add("@VerifiedOn", DBNull.Value);
hashtable.Add("@VerifiedThough", DBNull.Value);
hashtable.Add("@ClientRegistrationID", clientinfo.ClientRegistartionID);
hashtable.Add("@ClientSAID", DBNull.Value);
hashtable.Add("@ClientFeedback", DBNull.Value);
hashtable.Add("@AdvisorFeedback", DBNull.Value);
hashtable.Add("@AssignTo", DBNull.Value);
hashtable.Add("@ResignedDate", clientinfo.ResignedDate);
}
else if (Operation == 'V')
{
hashtable.Add("@ClientStatus", clientinfo.Status);
hashtable.Add("@VerifiedBy", DBNull.Value);
hashtable.Add("@VerifiedOn", clientinfo.VerifiedOn);
hashtable.Add("@VerifiedThough", clientinfo.VerifiedThough);
hashtable.Add("@ClientRegistrationID", clientinfo.ClientRegistartionID);
hashtable.Add("@ClientSAID", clientinfo.SAID);
hashtable.Add("@AssignTo", clientinfo.AssignTo);
hashtable.Add("@ClientFeedback", DBNull.Value);
hashtable.Add("@AdvisorFeedback", feedbackEntity.AdvisorFeedBack);
hashtable.Add("@ResignedDate", DBNull.Value);
}
else
{
hashtable.Add("@ClientStatus", DBNull.Value);
hashtable.Add("@VerifiedBy", DBNull.Value);
hashtable.Add("@VerifiedOn", DBNull.Value);
hashtable.Add("@VerifiedThough", DBNull.Value);
hashtable.Add("@ClientRegistrationID", DBNull.Value);
hashtable.Add("@ClientSAID", clientinfo.SAID);
hashtable.Add("@ClientFeedback", feedbackEntity.ClientFeedBack);
hashtable.Add("@AdvisorFeedback", DBNull.Value);
hashtable.Add("@AssignTo", DBNull.Value);
hashtable.Add("@ResignedDate", DBNull.Value);
}
hashtable.Add("@Operation", Operation);
DataUtilities dataUtilities = new DataUtilities();
int result = dataUtilities.ExecuteNonQuery("usp_ClientActions", hashtable);
return(result);
}
public int CUDclientinfo(ClientRegistrationEntity clientinfo, char Operation)
{
Hashtable hashtable = new Hashtable();
if (Operation == 'i')
{
hashtable.Add("@ClientRegistartionID", 0);
hashtable.Add("@VerifiedBy", DBNull.Value);
hashtable.Add("@VerifiedOn", DBNull.Value);
hashtable.Add("@VerifiedThough", DBNull.Value);
hashtable.Add("@Status", 1);
}
else
{
hashtable.Add("@ClientRegistartionID", clientinfo.ClientRegistartionID);
hashtable.Add("@VerifiedBy", DBNull.Value);
hashtable.Add("@VerifiedOn", DBNull.Value);
hashtable.Add("@VerifiedThough", DBNull.Value);
hashtable.Add("@Status", clientinfo.Status);
}
hashtable.Add("@SAID", clientinfo.SAID);
hashtable.Add("@Title", clientinfo.Title);
hashtable.Add("@FirstName", clientinfo.FirstName);
hashtable.Add("@LastName", clientinfo.LastName);
hashtable.Add("@EmailID", clientinfo.EmailID);
hashtable.Add("@MobileNumber", clientinfo.MobileNumber);
hashtable.Add("@Province", clientinfo.Province);
hashtable.Add("@City", clientinfo.City);
hashtable.Add("@Operation", Operation);
DataUtilities dataUtilities = new DataUtilities();
int result = dataUtilities.ExecuteNonQuery("ClientCRUD", hashtable);
return(result);
}
