public List <Project.Entity.Docs> getDocs(long PIN, long LogedUserID)
{
objResponse Response = new objResponse();
List <Project.Entity.Docs> Documents = new List <Project.Entity.Docs>();
try
{
SqlParameter[] sqlParameter = new SqlParameter[2];
sqlParameter[0] = new SqlParameter("@PIN", SqlDbType.BigInt, 10);
sqlParameter[0].Value = PIN;
sqlParameter[1] = new SqlParameter("@LogedUserID", SqlDbType.BigInt, 10);
sqlParameter[1].Value = LogedUserID;
DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_GetDocuments", sqlParameter, DB_CONSTANTS.ConnectionString_ERP_CRUZATA);
if (Response.ResponseData.Tables[0].Rows.Count > 0)
{
Response.ErrorCode = 0;
foreach (DataRow dr in Response.ResponseData.Tables[0].Rows)
{
Project.Entity.Docs objDoc = new Project.Entity.Docs();
objDoc.Doc_ID_Auto_PK = Convert.ToInt64(dr["Doc_ID_Auto_PK"]);
objDoc.Title = Convert.ToString(dr["Title"]);
objDoc.FileName = Convert.ToString(dr["FileName"]);
objDoc.FileID = Convert.ToString(dr["FileID"]);
objDoc.UploadedDate = Convert.ToDateTime(dr["UploadedDate"]);
objDoc.RelateToContact_ID = Convert.ToString(dr["RelateToContact_ID_FK"]);
objDoc.RelateToContact_Name = Convert.ToString(dr["ContactName"]);
objDoc.RelateToContact_ID = Convert.ToString(dr["RelateToDeal_ID_FK"]);
objDoc.RelateToContact_Name = Convert.ToString(dr["OwnerName"]);
objDoc.DocOwner_ID = Convert.ToInt64(dr["Owner_ID_Fk"]);
objDoc.DocOwner_Name = Convert.ToString(dr["OwnerName"]);
Documents.Add(objDoc);
}
}
else
{
Response.ErrorCode = 2001;
Response.ErrorMessage = "There is an Error. Please Try After some time.";
}
}
catch (Exception ex)
{
Response.ErrorCode = 3001;
Response.ErrorMessage = ex.Message.ToString();
BAL.Common.LogManager.LogError("getDocs", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(Documents);
}
public objResponse UpdateLeadEvent(long EventId, string Title, DateTime DateTimeScheduled, int AppointmentLength, long Disposition, string Note, long CreatedBy)
{
objResponse Response = new objResponse();
try
{
SqlParameter[] sqlParameter = new SqlParameter[7];
sqlParameter[0] = new SqlParameter("@Title", SqlDbType.NVarChar, 1000);
sqlParameter[0].Value = Title;
sqlParameter[1] = new SqlParameter("@DateTimeScheduled", SqlDbType.DateTime, 100);
sqlParameter[1].Value = DateTimeScheduled;
sqlParameter[2] = new SqlParameter("@AppointmentLength", SqlDbType.Int, 100);
sqlParameter[2].Value = AppointmentLength;
sqlParameter[3] = new SqlParameter("@Disposition", SqlDbType.BigInt, 16);
sqlParameter[3].Value = Disposition;
sqlParameter[4] = new SqlParameter("@Note", SqlDbType.NVarChar, 200);
sqlParameter[4].Value = Note;
sqlParameter[5] = new SqlParameter("@CreatedBy", SqlDbType.BigInt, 16);
sqlParameter[5].Value = CreatedBy;
sqlParameter[6] = new SqlParameter("@EventId", SqlDbType.BigInt, 16);
sqlParameter[6].Value = EventId;
DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_UpdateLeadEvent", sqlParameter, DB_CONSTANTS.ConnectionString_ICS);
if (Response.ResponseData.Tables[0].Rows.Count > 0)
{
Response.ErrorCode = 0;
Response.ErrorMessage = Response.ResponseData.Tables[0].Rows[0][0].ToString();
}
else
{
Response.ErrorCode = 2001;
Response.ErrorMessage = "There is an Error. Please Try After some time.";
}
}
catch (Exception ex)
{
Response.ErrorCode = 3001;
Response.ErrorMessage = ex.Message.ToString();
BAL.Common.LogManager.LogError("UpdateLeadEvent", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(Response);
}
public List <Opportunities> getAllOpportunities(long PIN)
{
objResponse Response = new objResponse();
List <Opportunities> opportunities = new List <Opportunities>();
try
{
SqlParameter[] sqlParameter = new SqlParameter[1];
sqlParameter[0] = new SqlParameter("@PIN", SqlDbType.BigInt, 10);
sqlParameter[0].Value = PIN;
DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_GetAllOpportunities", sqlParameter, DB_CONSTANTS.ConnectionString_ERP_CRUZATA);
if (Response.ResponseData.Tables[0].Rows.Count > 0)
{
Response.ErrorCode = 0;
foreach (DataRow dr in Response.ResponseData.Tables[0].Rows)
{
Opportunities objOpportunity = new Opportunities();
objOpportunity.Opportunity_ID = Convert.ToInt64(dr["Opportunity_ID_Auto_PK"]);
objOpportunity.Name = dr["Name"].ToString();
objOpportunity.Amount = dr["Amount"].ToString();
objOpportunity.RelateTo_Name = dr["RealtedTo"].ToString();
objOpportunity.RealateTo_ID = Convert.ToInt64(dr["Relate_To_ID_FK"]);
objOpportunity.stageId = dr["Stage"].ToString();
objOpportunity.Stage = dr["StageName"].ToString();
objOpportunity.Type = dr["Type"].ToString();
objOpportunity.Probability = dr["Probability"].ToString();
objOpportunity.AssignTO_ID = Convert.ToInt64(dr["AssignTo"]);
objOpportunity.AssignTO_Name = dr["AssignToName"].ToString();
objOpportunity.Description = dr["Description"].ToString();
objOpportunity.Source = dr["Source"].ToString();
opportunities.Add(objOpportunity);
}
}
else
{
Response.ErrorCode = 2001;
Response.ErrorMessage = "There is an Error. Please Try After some time.";
}
}
catch (Exception ex)
{
Response.ErrorCode = 3001;
Response.ErrorMessage = ex.Message.ToString();
BAL.Common.LogManager.LogError("getAllOpportunities", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(opportunities);
}
public objResponse AddPayment(long TrackingID, decimal AmountPaid, decimal ConvRate, DateTime Dat, string LogedUser)
{
objResponse Response = new objResponse();
try
{
SqlParameter[] sqlParameter = new SqlParameter[7];
sqlParameter[0] = new SqlParameter("@TrackingID", SqlDbType.BigInt, 10);
sqlParameter[0].Value = TrackingID;
sqlParameter[1] = new SqlParameter("@AmountPaid", SqlDbType.Decimal, 20);
sqlParameter[1].Value = AmountPaid;
sqlParameter[2] = new SqlParameter("@ConvRate", SqlDbType.Decimal, 20);
sqlParameter[2].Value = ConvRate;
sqlParameter[3] = new SqlParameter("@Date", SqlDbType.Date, 50);
sqlParameter[3].Value = Dat;
sqlParameter[4] = new SqlParameter("@CreatedBy", SqlDbType.NVarChar, 60);
sqlParameter[4].Value = LogedUser;
sqlParameter[5] = new SqlParameter("@CreatedDate", SqlDbType.DateTime, 50);
sqlParameter[5].Value = DateTime.Now;
sqlParameter[6] = new SqlParameter("@Status", SqlDbType.NVarChar, 20);
sqlParameter[6].Value = "Active";
DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_AddPayment", sqlParameter, DB_CONSTANTS.ConnectionString_ERP_CRUZATA);
if (Response.ResponseData.Tables[0].Rows.Count > 0)
{
Response.ErrorCode = 0;
Response.ErrorMessage = Response.ResponseData.Tables[0].Rows[0][0].ToString();
}
else
{
Response.ErrorCode = 2001;
Response.ErrorMessage = "There is an Error. Please Try After some time.";
}
}
catch (Exception ex)
{
Response.ErrorCode = 3001;
Response.ErrorMessage = ex.Message.ToString();
BAL.Common.LogManager.LogError("AddPayment", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(Response);
}
public List <Project.Entity.Clients> getClients(long PIN, long User_ID, string UserRole)
{
objResponse Response = new objResponse();
List <Project.Entity.Clients> clients = new List <Project.Entity.Clients>();
try
{
SqlParameter[] sqlParameter = new SqlParameter[3];
sqlParameter[0] = new SqlParameter("@PIN", SqlDbType.BigInt, 10);
sqlParameter[0].Value = PIN;
sqlParameter[1] = new SqlParameter("@User_ID", SqlDbType.BigInt, 10);
sqlParameter[1].Value = User_ID;
sqlParameter[2] = new SqlParameter("@UserRole", SqlDbType.NVarChar, 10);
sqlParameter[2].Value = UserRole;
DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_GetClients", sqlParameter, DB_CONSTANTS.ConnectionString_ERP_CRUZATA);
if (Response.ResponseData.Tables[0].Rows.Count > 0)
{
Response.ErrorCode = 0;
foreach (DataRow dr in Response.ResponseData.Tables[0].Rows)
{
Project.Entity.Clients objClient = new Project.Entity.Clients();
objClient.Client_ID_Auto_PK = Convert.ToInt64(dr["Client_ID_Auto_PK"]);
objClient.Name = Convert.ToString(dr["Name"]);
objClient.Date = Convert.ToDateTime(dr["Date"]);
objClient.Email = Convert.ToString(dr["Email"]);
objClient.SkypeNo = Convert.ToString(dr["SkypeNo"]);
objClient.Status = Convert.ToString(dr["Status"]);
objClient.AssignTO_Name = Convert.ToString(dr["AssignToUser"]);
clients.Add(objClient);
}
}
else
{
Response.ErrorCode = 2001;
Response.ErrorMessage = "There is an Error. Please Try After some time.";
}
}
catch (Exception ex)
{
Response.ErrorCode = 3001;
Response.ErrorMessage = ex.Message.ToString();
BAL.Common.LogManager.LogError("getClient", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(clients);
}
public List <LeadEvent> GetEventsInDatetimeRange(DateTime startDate, DateTime endDate)
{
objResponse Response = new objResponse();
List <LeadEvent> result = new List <LeadEvent>();
int i = 0;
try
{
SqlParameter[] sqlParameter = new SqlParameter[2];
sqlParameter[0] = new SqlParameter("@startDate", SqlDbType.DateTime, 1000);
sqlParameter[0].Value = startDate;
sqlParameter[1] = new SqlParameter("@endDate", SqlDbType.DateTime, 100);
sqlParameter[1].Value = endDate;
DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_GetLeadEvents", sqlParameter, DB_CONSTANTS.ConnectionString_ICS);
if (Response.ResponseData.Tables[0].Rows.Count > 0)
{
Response.ErrorCode = 0;
Response.ErrorMessage = Response.ResponseData.Tables[0].Rows[0][0].ToString();
foreach (DataRow dr in Response.ResponseData.Tables[0].Rows)
{
LeadEvent rec = new LeadEvent();
rec.ID = Convert.ToInt64(dr["LeadEvent_Id_Auto_Pk"]); //we dont link this back to anything as its a group summary but the fullcalendar needs unique IDs for each event item (unless its a repeating event)
// rec.Relatedlead = -1;
string StringDate = string.Format("{0:yyyy-MM-dd}", Convert.ToDateTime(dr["DateTimeScheduled"]));
rec.StartDateString = StringDate + "T00:00:00"; //ISO 8601 format
rec.EndDateString = StringDate + "T23:59:59";
rec.Title = dr["Title"].ToString();
result.Add(rec);
i++;
}
}
else
{
Response.ErrorCode = 2001;
Response.ErrorMessage = "There is an Error. Please Try After some time.";
}
}
catch (Exception ex)
{
Response.ErrorCode = 3001;
Response.ErrorMessage = ex.Message.ToString();
BAL.Common.LogManager.LogError("GetEventsInDatetimeRange", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(result);
}
public objResponse UpdateLeadDetails(long Lead_Id, string Status, string Notes, DateTime FollowupDate, long LogedUser)
{
objResponse Response = new objResponse();
try
{
SqlParameter[] sqlParameter = new SqlParameter[7];
sqlParameter[0] = new SqlParameter("@Lead_ID", SqlDbType.BigInt, 10);
sqlParameter[0].Value = Lead_Id;
sqlParameter[1] = new SqlParameter("@Status", SqlDbType.NVarChar, 20);
sqlParameter[1].Value = Status;
sqlParameter[2] = new SqlParameter("@Notes", SqlDbType.NVarChar, 4000);
sqlParameter[2].Value = Notes;
sqlParameter[3] = new SqlParameter("@CreatedBy", SqlDbType.BigInt, 10);
sqlParameter[3].Value = LogedUser;
sqlParameter[4] = new SqlParameter("@CreatedDate", SqlDbType.DateTime, 60);
sqlParameter[4].Value = DateTime.Now;
sqlParameter[5] = new SqlParameter("@DateTaken", SqlDbType.Date, 60);
sqlParameter[5].Value = DateTime.Now;
sqlParameter[6] = new SqlParameter("@FollowupDate", SqlDbType.Date, 60);
sqlParameter[6].Value = FollowupDate;
DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_UpdateLeadDetails", sqlParameter, DB_CONSTANTS.ConnectionString_ERP_CRUZATA);
if (Response.ResponseData.Tables[0].Rows.Count > 0)
{
Response.ErrorCode = 0;
Response.ErrorMessage = "Success";
}
else
{
Response.ErrorCode = 2001;
Response.ErrorMessage = "There is an Error. Please Try After some time.";
}
}
catch (Exception ex)
{
Response.ErrorCode = 3001;
Response.ErrorMessage = ex.Message.ToString();
BAL.Common.LogManager.LogError("UpdateLeadDetails", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(Response);
}
public objResponse SetGContactSeting(string access_token, string token_type, Int32 expires_in, string refresh_token, string reqType, long PIN, long logedUser)
{
objResponse Response = new objResponse();
try
{
SqlParameter[] sqlParameter = new SqlParameter[7];
sqlParameter[0] = new SqlParameter("@PIN", SqlDbType.BigInt, 50);
sqlParameter[0].Value = PIN;
sqlParameter[1] = new SqlParameter("@access_token", SqlDbType.NVarChar, 100);
sqlParameter[1].Value = access_token;
sqlParameter[2] = new SqlParameter("@token_type", SqlDbType.NVarChar, 100);
sqlParameter[2].Value = token_type;
sqlParameter[3] = new SqlParameter("@UserIDFk", SqlDbType.BigInt, 10);
sqlParameter[3].Value = logedUser;
sqlParameter[4] = new SqlParameter("@expires_in", SqlDbType.Int, 20);
sqlParameter[4].Value = expires_in;
sqlParameter[5] = new SqlParameter("@refresh_token", SqlDbType.NVarChar, 100);
sqlParameter[5].Value = refresh_token;
sqlParameter[6] = new SqlParameter("@reqType", SqlDbType.NVarChar, 40);
sqlParameter[6].Value = reqType;
DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_addDataSyncSeting", sqlParameter, DB_CONSTANTS.ConnectionString_ERP_CRUZATA);
if (Response.ResponseData.Tables[0].Rows.Count > 0)
{
Response.ErrorCode = 0;
Response.ErrorMessage = "Success";
}
else
{
Response.ErrorCode = 2001;
Response.ErrorMessage = "There is an Error. Please Try After some time.";
}
}
catch (Exception ex)
{
Response.ErrorCode = 3001;
Response.ErrorMessage = ex.Message.ToString();
BAL.Common.LogManager.LogError("SetGContactSeting", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(Response);
}
public objResponse SubmitData(LeadSubmision objLeads)
{
objResponse Response = new objResponse();
try
{
SqlParameter[] sqlParameter = new SqlParameter[32];
sqlParameter[0] = new SqlParameter("@businessName", SqlDbType.NVarChar, 100);
sqlParameter[0].Value = objLeads.businessName;
sqlParameter[1] = new SqlParameter("@contactName", SqlDbType.NVarChar, 100);
sqlParameter[1].Value = objLeads.contactName;
sqlParameter[2] = new SqlParameter("@contactPhone", SqlDbType.NVarChar, 13);
sqlParameter[2].Value = objLeads.contactPhone;
sqlParameter[3] = new SqlParameter("@Email", SqlDbType.NVarChar, 100);
sqlParameter[3].Value = objLeads.email;
sqlParameter[4] = new SqlParameter("@secondaryPhone", SqlDbType.NVarChar, 13);
sqlParameter[4].Value = objLeads.secondaryPhone;
sqlParameter[9] = new SqlParameter("@cooments", SqlDbType.NVarChar, 200);
sqlParameter[9].Value = objLeads.cooments;
DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_SubmitData", sqlParameter, DB_CONSTANTS.ConnectionString_ICS);
if (Response.ResponseData.Tables[0].Rows.Count > 0)
{
Response.ErrorCode = 0;
Response.ErrorMessage = Response.ResponseData.Tables[0].Rows[0][0].ToString();;
}
else
{
Response.ErrorCode = 2001;
Response.ErrorMessage = "There is an Error. Please Try After some time.";
}
}
catch (Exception ex)
{
Response.ErrorMessage = ex.Message.ToString();
BAL.Common.LogManager.LogError("SubmitData", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(Response);
}
public List <TextValue> GetOpportunityGraphData()
{
objResponse Response = new objResponse();
List <TextValue> OppoGraphData = new List <TextValue>();
try
{
DATA_ACCESS_LAYER.Fill(Response.ResponseData, "GetOpportunityGraphData", DB_CONSTANTS.ConnectionString_ERP_CRUZATA);
if (Response.ResponseData.Tables[0].Rows.Count > 0)
{
Response.ErrorCode = 0;
//foreach (DataRow dr in Response.ResponseData.Tables[0].Rows)
//{
// TextValue objText = new TextValue();
// objText.Value = dr["NoOfProjects"].ToString();
// objText.Text = dr["mont"].ToString();
// ProjGraphData.Add(objText);
//}
for (int i = 0; i < Convert.ToInt32(Response.ResponseData.Tables[1].Rows[0][0]); i++)
{
TextValue objText = new TextValue();
if (Response.ResponseData.Tables[0].Rows[0][i].ToString() == "")
{
objText.Value = "0";
}
else
{
objText.Value = Response.ResponseData.Tables[0].Rows[0][i].ToString();
}
objText.Text = i.ToString();
OppoGraphData.Add(objText);
}
}
else
{
Response.ErrorCode = 2001;
Response.ErrorMessage = "There is an Error. Please Try After some time.";
}
}
catch (Exception ex)
{
Response.ErrorCode = 3001;
Response.ErrorMessage = ex.Message.ToString();
BAL.Common.LogManager.LogError("GetOpportunityGraphData", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(OppoGraphData);
}
public List <Project.Entity.Meetings> getAllMeetings(long PIN)
{
objResponse Response = new objResponse();
List <Project.Entity.Meetings> Meetings = new List <Project.Entity.Meetings>();
try
{
SqlParameter[] sqlParameter = new SqlParameter[1];
sqlParameter[0] = new SqlParameter("@PIN", SqlDbType.BigInt, 10);
sqlParameter[0].Value = PIN;
DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_GetMeetingsByPin", sqlParameter, DB_CONSTANTS.ConnectionString_ERP_CRUZATA);
if (Response.ResponseData.Tables[0].Rows.Count > 0)
{
Response.ErrorCode = 0;
foreach (DataRow dr in Response.ResponseData.Tables[0].Rows)
{
Project.Entity.Meetings objMeeting = new Project.Entity.Meetings();
objMeeting.Meeting_ID_PK = Convert.ToInt64(dr["Meeting_ID_Auto_PK"]);
objMeeting.Title = Convert.ToString(dr["Title"]);
objMeeting.Date = Convert.ToDateTime(dr["Date"]).ToString("d MMM yyyy");
objMeeting.Agenda = Convert.ToString(dr["Agenda"]);
objMeeting.RelateTo = Convert.ToInt64(dr["RelateTo_ID_Fk"]);
objMeeting.RelateToName = Convert.ToString(dr["Name"]);
objMeeting.CreatedBy = Convert.ToString(dr["CreatedBy"]);
objMeeting.CreatedByName = Convert.ToString(dr["CreatedByName"]);
objMeeting.Status = Convert.ToString(dr["Status"]);
objMeeting.Summary = Convert.ToString(dr["Summary"]);
Meetings.Add(objMeeting);
}
}
else
{
Response.ErrorCode = 2001;
Response.ErrorMessage = "There is an Error. Please Try After some time.";
}
}
catch (Exception ex)
{
Response.ErrorCode = 3001;
Response.ErrorMessage = ex.Message.ToString();
BAL.Common.LogManager.LogError("getAllMeetings", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(Meetings);
}
public List <LeadEvent> GetLeadEventsInDatetimeRangeForTransfer(DateTime startDate, DateTime endDate)
{
objResponse Response = new objResponse();
List <LeadEvent> result = new List <LeadEvent>();
int i = 0;
try
{
SqlParameter[] sqlParameter = new SqlParameter[2];
sqlParameter[0] = new SqlParameter("@startDate", SqlDbType.DateTime, 1000);
sqlParameter[0].Value = startDate;
sqlParameter[1] = new SqlParameter("@endDate", SqlDbType.DateTime, 100);
sqlParameter[1].Value = endDate;
DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_GetLeadEvents", sqlParameter, DB_CONSTANTS.ConnectionString_ICS);
if (Response.ResponseData.Tables[0].Rows.Count > 0)
{
Response.ErrorCode = 0;
Response.ErrorMessage = Response.ResponseData.Tables[0].Rows[0][0].ToString();
foreach (DataRow dr in Response.ResponseData.Tables[0].Rows)
{
LeadEvent rec = new LeadEvent();
rec.ID = Convert.ToInt64(dr["LeadEvent_Id_Auto_Pk"]); //we dont link this back to anything as its a group summary but the fullcalendar needs unique IDs for each event item (unless its a repeating event)
rec.StartDateString = Convert.ToDateTime(dr["DateTimeScheduled"]).ToString("MM/dd/yy HH:mm"); // "s" is a preset format that outputs as: "2009-02-27T12:12:22"
//rec.EndDateString = Convert.ToDateTime(dr["DateTimeScheduled"]).AddMinutes(Convert.ToInt32(dr["AppointmentLength"])).ToString("MM/dd/yy HH:mm"); // field AppointmentLength is in minutes
rec.Title = dr["Title"].ToString();
rec.StatusColor = dr["Colour"].ToString();;
result.Add(rec);
}
}
else
{
Response.ErrorCode = 2001;
Response.ErrorMessage = "There is an Error. Please Try After some time.";
}
}
catch (Exception ex)
{
Response.ErrorCode = 3001;
Response.ErrorMessage = ex.Message.ToString();
BAL.Common.LogManager.LogError("LoadEventsInDatetimeRange", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(result);
}
public objResponse AddNote(long Relate_To_ID, string Note, long LogedUser, long OwnerID, string RelatedTable)
{
objResponse Response = new objResponse();
try
{
SqlParameter[] sqlParameter = new SqlParameter[6];
sqlParameter[0] = new SqlParameter("@Relate_To_ID", SqlDbType.BigInt, 10);
sqlParameter[0].Value = Relate_To_ID;
sqlParameter[1] = new SqlParameter("@Note", SqlDbType.NVarChar, 4000);
sqlParameter[1].Value = Note;
sqlParameter[2] = new SqlParameter("@CreatedBy", SqlDbType.BigInt, 60);
sqlParameter[2].Value = LogedUser;
sqlParameter[3] = new SqlParameter("@CreatedDate", SqlDbType.DateTime, 60);
sqlParameter[3].Value = DateTime.Now;
sqlParameter[4] = new SqlParameter("OwnerID", SqlDbType.BigInt, 10);
sqlParameter[4].Value = OwnerID;
sqlParameter[5] = new SqlParameter("@RelatedTable", SqlDbType.NVarChar, 100);
sqlParameter[5].Value = RelatedTable;
DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_AddNote", sqlParameter, DB_CONSTANTS.ConnectionString_ICS);
if (Response.ResponseData.Tables[0].Rows.Count > 0)
{
Response.ErrorCode = 0;
Response.ErrorMessage = Response.ResponseData.Tables[0].Rows[0][0].ToString();
}
else
{
Response.ErrorCode = 2001;
Response.ErrorMessage = "There is an Error. Please Try After some time.";
}
}
catch (Exception ex)
{
Response.ErrorCode = 3001;
Response.ErrorMessage = ex.Message.ToString();
BAL.Common.LogManager.LogError("AddNote", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(Response);
}
public List <Project.Entity.Projects> getProjects()
{
objResponse Response = new objResponse();
List <Project.Entity.Projects> projects = new List <Project.Entity.Projects>();
try
{
DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_GetProjects", DB_CONSTANTS.ConnectionString_ERP_CRUZATA);
if (Response.ResponseData.Tables[0].Rows.Count > 0)
{
Response.ErrorCode = 0;
foreach (DataRow dr in Response.ResponseData.Tables[0].Rows)
{
Project.Entity.Projects objProjects = new Project.Entity.Projects();
objProjects.Project_ID_PK = Convert.ToInt64(dr["Project_ID_Auto_PK"]);
objProjects.Title = Convert.ToString(dr["Title"]);
objProjects.Date = Convert.ToDateTime(dr["Date"]);
objProjects.CategoryName = Convert.ToString(dr["CategoryName"]);
objProjects.ClientName = Convert.ToString(dr["Name"]);
objProjects.Model = Convert.ToString(dr["Model"]);
objProjects.Status = Convert.ToString(dr["Status"]);
objProjects.ProjectCost = Convert.ToString(dr["ProjectCost"]);
if (Convert.ToString(dr["ClientSign"]) != "")
{
objProjects.isSigned = true;
}
else
{
objProjects.isSigned = false;
}
projects.Add(objProjects);
}
}
else
{
Response.ErrorCode = 2001;
Response.ErrorMessage = "There is an Error. Please Try After some time.";
}
}
catch (Exception ex)
{
Response.ErrorCode = 3001;
Response.ErrorMessage = ex.Message.ToString();
BAL.Common.LogManager.LogError("getProject", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(projects);
}
public objResponse AddEstimationUpload(long Estimation_ID, string FileName, string LogedUser, long Comment_ID_FK)
{
objResponse Response = new objResponse();
try
{
SqlParameter[] sqlParameter = new SqlParameter[6];
sqlParameter[0] = new SqlParameter("@Estimation_ID", SqlDbType.BigInt, 50);
sqlParameter[0].Value = Estimation_ID;
sqlParameter[1] = new SqlParameter("@FileName", SqlDbType.NVarChar, 200);
sqlParameter[1].Value = FileName;
sqlParameter[2] = new SqlParameter("@CreatedBy", SqlDbType.NVarChar, 60);
sqlParameter[2].Value = LogedUser;
sqlParameter[3] = new SqlParameter("@CreatedDate", SqlDbType.DateTime, 50);
sqlParameter[3].Value = DateTime.Now;
sqlParameter[4] = new SqlParameter("@Status", SqlDbType.NVarChar, 20);
sqlParameter[4].Value = "Active";
sqlParameter[5] = new SqlParameter("@Comment_ID_FK", SqlDbType.BigInt, 60);
sqlParameter[5].Value = Comment_ID_FK;
DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_AddEstimationUploads", sqlParameter, DB_CONSTANTS.ConnectionString_ERP_CRUZATA);
if (Response.ResponseData.Tables[0].Rows.Count > 0)
{
Response.ErrorCode = 0;
Response.ErrorMessage = Response.ResponseData.Tables[0].Rows[0][0].ToString();
}
else
{
Response.ErrorCode = 2001;
Response.ErrorMessage = "There is an Error. Please Try After some time.";
}
}
catch (Exception ex)
{
Response.ErrorCode = 3001;
Response.ErrorMessage = ex.Message.ToString();
BAL.Common.LogManager.LogError("AddEstimationUpload", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(Response);
}
public objResponse UpdateEventType1(int EventId, string Title, DateTime StartDate, DateTime EndDate, string Description, long CreatedBy)
{
objResponse Response = new objResponse();
try
{
SqlParameter[] sqlParameter = new SqlParameter[6];
sqlParameter[0] = new SqlParameter("@Title", SqlDbType.NVarChar, 1000);
sqlParameter[0].Value = Title;
sqlParameter[1] = new SqlParameter("@StartDate", SqlDbType.DateTime, 60);
sqlParameter[1].Value = StartDate;
sqlParameter[2] = new SqlParameter("@EndDate", SqlDbType.DateTime, 60);
sqlParameter[2].Value = EndDate;
sqlParameter[3] = new SqlParameter("@CreatedBy", SqlDbType.BigInt, 16);
sqlParameter[3].Value = CreatedBy;
sqlParameter[4] = new SqlParameter("@Description", SqlDbType.NVarChar, 200);
sqlParameter[4].Value = Description;
sqlParameter[5] = new SqlParameter("@EventId", SqlDbType.Int, 10);
sqlParameter[5].Value = EventId;
DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_UpdateEvent1", sqlParameter, DB_CONSTANTS.ConnectionString_ICS);
if (Response.ResponseData.Tables[0].Rows.Count > 0)
{
Response.ErrorCode = 0;
Response.ErrorMessage = Response.ResponseData.Tables[0].Rows[0][0].ToString();
}
else
{
Response.ErrorCode = 2001;
Response.ErrorMessage = "There is an Error. Please Try After some time.";
}
}
catch (Exception ex)
{
Response.ErrorCode = 3001;
Response.ErrorMessage = ex.Message.ToString();
BAL.Common.LogManager.LogError("UpdateEventType1", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(Response);
}
public objResponse ManageDroplistOption(string Option, long OptionID, string Module, string DropName, long CustomerID, long logedUser)
{
objResponse Response = new objResponse();
try
{
SqlParameter[] sqlParameter = new SqlParameter[6];
sqlParameter[0] = new SqlParameter("@CustomerID", SqlDbType.BigInt, 50);
sqlParameter[0].Value = CustomerID;
sqlParameter[1] = new SqlParameter("@Option", SqlDbType.NVarChar, 100);
sqlParameter[1].Value = Option;
sqlParameter[2] = new SqlParameter("@OptionID", SqlDbType.BigInt, 10);
sqlParameter[2].Value = OptionID;
sqlParameter[3] = new SqlParameter("@CreatedBy", SqlDbType.BigInt, 10);
sqlParameter[3].Value = logedUser;
sqlParameter[4] = new SqlParameter("@Module", SqlDbType.NVarChar, 50);
sqlParameter[4].Value = Module;
sqlParameter[5] = new SqlParameter("@DropName", SqlDbType.NVarChar, 50);
sqlParameter[5].Value = DropName;
DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_AddDropListOption", sqlParameter, DB_CONSTANTS.ConnectionString_ERP_CRUZATA);
if (Response.ResponseData.Tables[0].Rows.Count > 0)
{
Response.ErrorCode = 0;
Response.ErrorMessage = "Success";
}
else
{
Response.ErrorCode = 2001;
Response.ErrorMessage = "There is an Error. Please Try After some time.";
}
}
catch (Exception ex)
{
Response.ErrorCode = 3001;
Response.ErrorMessage = ex.Message.ToString();
BAL.Common.LogManager.LogError("ManageDroplistOptio", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(Response);
}
public List <Project.Entity.Chat> GetUsersChat(string Sender, string Reciever, string PIN)
{
objResponse Response = new objResponse();
List <Project.Entity.Chat> chat = new List <Project.Entity.Chat>();
try
{
SqlParameter[] sqlParameter = new SqlParameter[3];
sqlParameter[0] = new SqlParameter("@Sender", SqlDbType.BigInt, 10);
sqlParameter[0].Value = Convert.ToInt64(Sender);
sqlParameter[1] = new SqlParameter("@Reciever", SqlDbType.BigInt, 10);
sqlParameter[1].Value = Convert.ToInt64(Reciever);
sqlParameter[2] = new SqlParameter("@PIN", SqlDbType.BigInt, 10);
sqlParameter[2].Value = Convert.ToInt64(PIN);
DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_GetUserChat", sqlParameter, DB_CONSTANTS.ConnectionString_ERP_CRUZATA);
if (Response.ResponseData.Tables[0].Rows.Count > 0)
{
Response.ErrorCode = 0;
foreach (DataRow dr in Response.ResponseData.Tables[0].Rows)
{
Project.Entity.Chat objUserChat = new Project.Entity.Chat();
objUserChat.Msg = dr["Msg"].ToString();
objUserChat.SenderID = Convert.ToInt64(dr["Sender_ID"]);
objUserChat.RecieverID = Convert.ToInt64(dr["Reciever_ID"]);
objUserChat.Date = Convert.ToString(dr["date"]);
chat.Add(objUserChat);
}
}
else
{
Response.ErrorCode = 2001;
Response.ErrorMessage = "There is an Error. Please Try After some time.";
}
}
catch (Exception ex)
{
Response.ErrorMessage = ex.Message.ToString();
BAL.Common.LogManager.LogError("GetUsersChat", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(chat);
}
public objResponse EditStatus(string Name, string color, string template, string textTemplate, long StatusID, long LogedUser)
{
objResponse Response = new objResponse();
try
{
SqlParameter[] sqlParameter = new SqlParameter[6];
sqlParameter[0] = new SqlParameter("@Name", SqlDbType.NVarChar, 100);
sqlParameter[0].Value = Name;
sqlParameter[1] = new SqlParameter("@color", SqlDbType.NVarChar, 100);
sqlParameter[1].Value = color;
sqlParameter[2] = new SqlParameter("@template", SqlDbType.NVarChar, 4000);
sqlParameter[2].Value = template;
sqlParameter[3] = new SqlParameter("@textTemplate", SqlDbType.NVarChar, 4000);
sqlParameter[3].Value = textTemplate;
sqlParameter[4] = new SqlParameter("@LogedUser", SqlDbType.BigInt, 20);
sqlParameter[4].Value = LogedUser;
sqlParameter[5] = new SqlParameter("@StatusID", SqlDbType.BigInt, 20);
sqlParameter[5].Value = StatusID;
DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_EditStatus", sqlParameter, DB_CONSTANTS.ConnectionString_ICS);
if (Response.ResponseData.Tables[0].Rows.Count > 0)
{
Response.ErrorCode = 0;
Response.ErrorMessage = Response.ResponseData.Tables[0].Rows[0][0].ToString();
}
else
{
Response.ErrorCode = 2001;
Response.ErrorMessage = "There is an Error. Please Try After some time.";
}
}
catch (Exception ex)
{
Response.ErrorCode = 2001;
Response.ErrorMessage = "Error while processing: " + ex.Message;
BAL.Common.LogManager.LogError("EditStatus", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(Response);
}
public List <Users> GetUsers()
{
objResponse Response = new objResponse();
List <Users> user = new List <Users>();
try
{
DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_GetAllUsers", DB_CONSTANTS.ConnectionString_ICS);
if (Response.ResponseData.Tables[0].Rows.Count > 0)
{
Response.ErrorCode = 0;
foreach (DataRow dr in Response.ResponseData.Tables[0].Rows)
{
Users objUser = new Users();
objUser.User_ID = Convert.ToInt64(dr["User_ID_Auto_PK"]);
objUser.FName = dr["User_FirstName"].ToString();
objUser.LName = dr["User_LastName"].ToString();
objUser.Email = dr["User_Email"].ToString();
objUser.Username = dr["UserName"].ToString();
objUser.Mobile = dr["User_Contact"].ToString();
objUser.URoleName = dr["RoleName"].ToString();
objUser.TimeZone = dr["Time_Zone"].ToString();
objUser.Status = dr["Status"].ToString();
if (objUser.Status != "Deactive")
{
objUser.LastLogin = Convert.ToDateTime(dr["LastLogin"]);
}
user.Add(objUser);
}
}
else
{
Response.ErrorCode = 2001;
Response.ErrorMessage = "There is an Error. Please Try After some time.";
}
}
catch (Exception ex)
{
Response.ErrorMessage = ex.Message.ToString();
BAL.Common.LogManager.LogError("GetUsers", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(user);
}
public List <TextValue> GetOpportunityWonByMonth(long PIN)
{
objResponse Response = new objResponse();
List <TextValue> OppoData = new List <TextValue>();
try
{
SqlParameter[] sqlParameter = new SqlParameter[1];
sqlParameter[0] = new SqlParameter("@PIN", SqlDbType.BigInt, 10);
sqlParameter[0].Value = PIN;
DATA_ACCESS_LAYER.Fill(Response.ResponseData, "GetWonOpportunityDataByMonth", sqlParameter, DB_CONSTANTS.ConnectionString_ERP_CRUZATA);
if (Response.ResponseData.Tables[0].Rows.Count > 0)
{
Response.ErrorCode = 0;
for (int i = 0; i < Convert.ToInt32(Response.ResponseData.Tables[1].Rows[0][0]); i++)
{
TextValue objText = new TextValue();
if (Response.ResponseData.Tables[0].Rows[0][i].ToString() == "")
{
objText.Value = "0";
}
else
{
objText.Value = Response.ResponseData.Tables[0].Rows[0][i].ToString();
}
objText.Text = i.ToString();
OppoData.Add(objText);
}
}
else
{
Response.ErrorCode = 2001;
Response.ErrorMessage = "There is an Error. Please Try After some time.";
}
}
catch (Exception ex)
{
Response.ErrorCode = 3001;
Response.ErrorMessage = ex.Message.ToString();
BAL.Common.LogManager.LogError("GetOpportunityWonByMonth", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(OppoData);
}
public objResponse AddUserchat(string SenderID, string RecieverID, string Msg, string PIN, long LogedUserID)
{
objResponse Response = new objResponse();
try
{
SqlParameter[] sqlParameter = new SqlParameter[6];
sqlParameter[0] = new SqlParameter("@SenderID", SqlDbType.BigInt, 10);
sqlParameter[0].Value = Convert.ToInt64(SenderID);
sqlParameter[1] = new SqlParameter("@RecieverID", SqlDbType.BigInt, 10);
sqlParameter[1].Value = Convert.ToInt64(RecieverID);
sqlParameter[2] = new SqlParameter("@Msg", SqlDbType.NVarChar, 4000);
sqlParameter[2].Value = Msg;
sqlParameter[3] = new SqlParameter("@Date", SqlDbType.DateTime, 10);
sqlParameter[3].Value = DateTime.Now;
sqlParameter[4] = new SqlParameter("@PIN", SqlDbType.BigInt, 10);
sqlParameter[4].Value = Convert.ToInt64(PIN);
sqlParameter[5] = new SqlParameter("@LogedUserID", SqlDbType.BigInt, 10);
sqlParameter[5].Value = LogedUserID;
DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_AddUserChat", sqlParameter, DB_CONSTANTS.ConnectionString_ERP_CRUZATA);
if (Response.ResponseData.Tables[0].Rows.Count > 0)
{
Response.ErrorCode = 0;
Response.ErrorMessage = "Success";
}
else
{
Response.ErrorCode = 2001;
Response.ErrorMessage = "Error";
}
}
catch (Exception ex)
{
Response.ErrorMessage = ex.Message.ToString();
BAL.Common.LogManager.LogError("AddUserchat", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(Response);
}
public objResponse AddPlans(string Name, string Price, string PlanType, string Currency, string planID)
{
objResponse response = new objResponse();
try
{
SqlParameter[] sqlParameter = new SqlParameter[5];
sqlParameter[0] = new SqlParameter("@Name", SqlDbType.NVarChar, 50);
sqlParameter[0].Value = Name;
sqlParameter[1] = new SqlParameter("@Price", SqlDbType.NVarChar, 20);
sqlParameter[1].Value = Price;
sqlParameter[2] = new SqlParameter("@PlanType", SqlDbType.NVarChar, 30);
sqlParameter[2].Value = PlanType;
sqlParameter[3] = new SqlParameter("@Currency", SqlDbType.NVarChar, 30);
sqlParameter[3].Value = Currency;
sqlParameter[4] = new SqlParameter("@planID", SqlDbType.NVarChar, 50);
sqlParameter[4].Value = planID;
DATA_ACCESS_LAYER.Fill(response.ResponseData, "usp_AddPlan", sqlParameter, DB_CONSTANTS.ConnectionString_ERP_CRUZATA);
if (response.ResponseData.Tables[0].Rows.Count > 0)
{
response.ErrorCode = 0;
response.ErrorMessage = response.ResponseData.Tables[0].Rows[0][0].ToString();
}
else
{
response.ErrorCode = 2001;
response.ErrorMessage = "There is an error, please try after some time";
}
}
catch (Exception ex)
{
response.ErrorCode = 3001;
response.ErrorMessage = ex.Message.ToString();
BAL.Common.LogManager.LogError("Add Plans", 1, Convert.ToString(ex.Message), Convert.ToString(ex.Source), Convert.ToString(ex.StackTrace));
}
return(response);
}
public List <Users> GetUsers(string PIN)
{
objResponse Response = new objResponse();
List <Users> user = new List <Users>();
try
{
SqlParameter[] sqlParameter = new SqlParameter[1];
sqlParameter[0] = new SqlParameter("@PIN", SqlDbType.BigInt, 10);
sqlParameter[0].Value = Convert.ToInt64(PIN);
DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_GetUsers", sqlParameter, DB_CONSTANTS.ConnectionString_ERP_CRUZATA);
if (Response.ResponseData.Tables[0].Rows.Count > 0)
{
Response.ErrorCode = 0;
foreach (DataRow dr in Response.ResponseData.Tables[0].Rows)
{
Users objUser = new Users();
objUser.User_ID_PK = Convert.ToInt64(dr["User_ID_Auto_PK"]);
objUser.Uid = dr["UserId"].ToString();
objUser.FullName = dr["User_FirstName"].ToString() + " " + dr["User_LastName"].ToString();
objUser.Email = dr["User_Email"].ToString();
objUser.Status = dr["Status"].ToString();
objUser.Date = Convert.ToDateTime(dr["CreatedDate"]);
objUser.UserType = dr["User_Type"].ToString();
user.Add(objUser);
}
}
else
{
Response.ErrorCode = 2001;
Response.ErrorMessage = "There is an Error. Please Try After some time.";
}
}
catch (Exception ex)
{
Response.ErrorMessage = ex.Message.ToString();
BAL.Common.LogManager.LogError("GetUsers", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(user);
}
public objResponse UpdateEventDate(int Eventid, DateTime StartDate, DateTime EndDate, long CreatedBY, long PIN)
{
objResponse Response = new objResponse();
try
{
SqlParameter[] sqlParameter = new SqlParameter[5];
sqlParameter[0] = new SqlParameter("@Eventid", SqlDbType.Int, 10);
sqlParameter[0].Value = Eventid;
sqlParameter[1] = new SqlParameter("@StartDate", SqlDbType.DateTime, 60);
sqlParameter[1].Value = StartDate;
sqlParameter[2] = new SqlParameter("@EndDate", SqlDbType.DateTime, 60);
sqlParameter[2].Value = EndDate;
sqlParameter[3] = new SqlParameter("@CreatedBY", SqlDbType.BigInt, 20);
sqlParameter[3].Value = CreatedBY;
sqlParameter[4] = new SqlParameter("@PIN", SqlDbType.BigInt, 20);
sqlParameter[4].Value = PIN;
DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_UpdateEventDate", sqlParameter, DB_CONSTANTS.ConnectionString_ERP_CRUZATA);
if (Response.ResponseData.Tables[0].Rows.Count > 0)
{
Response.ErrorCode = 0;
Response.ErrorMessage = Response.ResponseData.Tables[0].Rows[0][0].ToString();
}
else
{
Response.ErrorCode = 2001;
Response.ErrorMessage = "There is an Error. Please Try After some time.";
}
}
catch (Exception ex)
{
Response.ErrorCode = 3001;
Response.ErrorMessage = ex.Message.ToString();
BAL.Common.LogManager.LogError("UpdateEventDate", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(Response);
}
public objResponse DeleteEvent(long EventID, long RelateToID, string RelatedTable, long LogedUser, long PIN)
{
objResponse Response = new objResponse();
try
{
SqlParameter[] sqlParameter = new SqlParameter[5];
sqlParameter[0] = new SqlParameter("@EventID", SqlDbType.BigInt, 10);
sqlParameter[0].Value = EventID;
sqlParameter[1] = new SqlParameter("@RelateToID", SqlDbType.BigInt, 10);
sqlParameter[1].Value = RelateToID;
sqlParameter[2] = new SqlParameter("@RelatedTable", SqlDbType.NVarChar, 20);
sqlParameter[2].Value = RelatedTable;
sqlParameter[3] = new SqlParameter("@LogedUser", SqlDbType.BigInt, 10);
sqlParameter[3].Value = LogedUser;
sqlParameter[4] = new SqlParameter("@PIN", SqlDbType.BigInt, 10);
sqlParameter[4].Value = PIN;
DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_DaleteEvents", sqlParameter, DB_CONSTANTS.ConnectionString_ERP_CRUZATA);
if (Response.ResponseData.Tables[0].Rows.Count > 0)
{
Response.ErrorCode = 0;
Response.ErrorMessage = "success";
}
else
{
Response.ErrorCode = 2001;
Response.ErrorMessage = "There is an Error. Please Try After some time.";
}
}
catch (Exception ex)
{
Response.ErrorCode = 3001;
Response.ErrorMessage = ex.Message.ToString();
BAL.Common.LogManager.LogError("DeleteEvent", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(Response);
}
public static List<TextValue> getRelatedUserListing(long PIN, long logedUser, string RelatedTable)
{
objResponse Response = new objResponse();
List<TextValue> rlist = new List<TextValue>();
try
{
SqlParameter[] sqlParameter = new SqlParameter[3];
sqlParameter[0] = new SqlParameter("@PIN", SqlDbType.BigInt, 10);
sqlParameter[0].Value = PIN;
sqlParameter[1] = new SqlParameter("@RelateToID", SqlDbType.BigInt, 10);
sqlParameter[1].Value = logedUser;
sqlParameter[2] = new SqlParameter("@RelatedTable", SqlDbType.NVarChar, 30);
sqlParameter[2].Value = RelatedTable;
DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_GetRelateTOListing", sqlParameter, DB_CONSTANTS.ConnectionString_ERP_CRUZATA);
if (Response.ResponseData.Tables[0].Rows.Count > 0)
{
Response.ErrorCode = 0;
foreach (DataRow dr in Response.ResponseData.Tables[0].Rows)
{
TextValue objTV = new TextValue();
objTV.Value = Convert.ToString(dr["RelateToID"]);
objTV.Text = Convert.ToString(dr["RelateToName"]);
rlist.Add(objTV);
}
}
else
{
Response.ErrorCode = 2001;
Response.ErrorMessage = "There is an Error. Please Try After some time.";
}
}
catch (Exception ex)
{
Response.ErrorCode = 3001;
Response.ErrorMessage = ex.Message.ToString();
BAL.Common.LogManager.LogError("getRelatedUserListing", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return rlist;
}
public List <Project.ViewModel.ProjectSowViewModel> getProjectSow(long Project_ID)
{
objResponse Response = new objResponse();
List <Project.ViewModel.ProjectSowViewModel> projectSow = new List <Project.ViewModel.ProjectSowViewModel>();
try
{
SqlParameter[] sqlParameter = new SqlParameter[1];
sqlParameter[0] = new SqlParameter("@Project_ID", SqlDbType.BigInt, 10);
sqlParameter[0].Value = Project_ID;
DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_GetProjectSow", sqlParameter, DB_CONSTANTS.ConnectionString_ERP_CRUZATA);
if (Response.ResponseData.Tables[0].Rows.Count > 0)
{
Response.ErrorCode = 0;
foreach (DataRow dr in Response.ResponseData.Tables[0].Rows)
{
Project.ViewModel.ProjectSowViewModel objProjectSow = new Project.ViewModel.ProjectSowViewModel();
objProjectSow.Task = Convert.ToString(dr["Task"]);
objProjectSow.Description = Convert.ToString(dr["Description"]);
objProjectSow.Hours = Convert.ToString(dr["Hours"]);
objProjectSow.Price = Convert.ToString(dr["Price"]);
projectSow.Add(objProjectSow);
}
}
else
{
Response.ErrorCode = 2001;
Response.ErrorMessage = "There is an Error. Please Try After some time.";
}
}
catch (Exception ex)
{
Response.ErrorCode = 3001;
Response.ErrorMessage = ex.Message.ToString();
BAL.Common.LogManager.LogError("getProjectSow", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(projectSow);
}
public List <Project.ViewModel.ProjectPaymentDataViewModel> getProjectPaymentData(long Project_ID)
{
objResponse Response = new objResponse();
List <Project.ViewModel.ProjectPaymentDataViewModel> projectPaymentData = new List <Project.ViewModel.ProjectPaymentDataViewModel>();
try
{
SqlParameter[] sqlParameter = new SqlParameter[1];
sqlParameter[0] = new SqlParameter("@Project_ID", SqlDbType.BigInt, 10);
sqlParameter[0].Value = Project_ID;
DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_GetProjectPaymentData", sqlParameter, DB_CONSTANTS.ConnectionString_ERP_CRUZATA);
if (Response.ResponseData.Tables[0].Rows.Count > 0)
{
Response.ErrorCode = 0;
foreach (DataRow dr in Response.ResponseData.Tables[0].Rows)
{
Project.ViewModel.ProjectPaymentDataViewModel objProjectPaymentData = new Project.ViewModel.ProjectPaymentDataViewModel();
objProjectPaymentData.DueDate = Convert.ToDateTime(dr["Date"]).ToString("d MMM yyyy");
objProjectPaymentData.Upfront = Convert.ToString(dr["Upfront"]);
objProjectPaymentData.Remaining = Convert.ToString(dr["Remaining"]);
projectPaymentData.Add(objProjectPaymentData);
}
}
else
{
Response.ErrorCode = 2001;
Response.ErrorMessage = "There is an Error. Please Try After some time.";
}
}
catch (Exception ex)
{
Response.ErrorCode = 3001;
Response.ErrorMessage = ex.Message.ToString();
BAL.Common.LogManager.LogError("getProjectPaymentData", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(projectPaymentData);
}
public List <Project.Entity.Estimate> getEstimate()
{
objResponse Response = new objResponse();
List <Project.Entity.Estimate> Estimate = new List <Project.Entity.Estimate>();
try
{
DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_GetEstimate", DB_CONSTANTS.ConnectionString_ERP_CRUZATA);
if (Response.ResponseData.Tables[0].Rows.Count > 0)
{
Response.ErrorCode = 0;
foreach (DataRow dr in Response.ResponseData.Tables[0].Rows)
{
Project.Entity.Estimate objEstimate = new Project.Entity.Estimate();
objEstimate.Estimate_ID_Auto_PK = Convert.ToInt64(dr["Estimation_ID_Auto_PK"]);
objEstimate.Lead = Convert.ToString(dr["Lead"]);
objEstimate.Client = Convert.ToString(dr["Client"]);
objEstimate.Priority = Convert.ToString(dr["Priority"]);
objEstimate.Date = Convert.ToDateTime(dr["Date"]);
objEstimate.CategoryName = Convert.ToString(dr["CategoryName"]);
objEstimate.LanguageName = Convert.ToString(dr["Language"]);
objEstimate.Assigne = Convert.ToString(dr["FullName"]);
objEstimate.Status = Convert.ToString(dr["Status"]);
Estimate.Add(objEstimate);
}
}
else
{
Response.ErrorCode = 2001;
Response.ErrorMessage = "There is an Error. Please Try After some time.";
}
}
catch (Exception ex)
{
Response.ErrorCode = 3001;
Response.ErrorMessage = ex.Message.ToString();
BAL.Common.LogManager.LogError("getEstimate", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(Estimate);
}
