public objResponse getsaleRepByID(long srcId)
{
objResponse Response = new objResponse();
try
{
SqlParameter[] sqlParameter = new SqlParameter[1];
sqlParameter[0] = new SqlParameter("@srcId", SqlDbType.BigInt, 10);
sqlParameter[0].Value = srcId;
DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_getSalesrepIdBySource", sqlParameter, DB_CONSTANTS.ConnectionString_ICS);
if (Response.ResponseData.Tables[0].Rows.Count > 0)
{
Response.ErrorCode = 0;
Response.ErrorMessage = "Suceess";
}
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("getLeadForEditByID", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(Response);
}
public RegistrationResponse registerUser(Users users)
{
objResponse Response = new objResponse();
RegistrationResponse results = new RegistrationResponse();
try
{
using (var client = new HttpClient())
{
client.BaseAddress = new Uri("http://zmetricsapi.cruzata.com/auth/register");
//HTTP POST
var postTask = client.PostAsJsonAsync <Users>("register", users);
postTask.Wait();
var result = postTask.Result;
if (result.IsSuccessStatusCode)
{
var readTask = result.Content.ReadAsAsync <RegistrationResponse>();
readTask.Wait();
results = readTask.Result;
}
}
}
catch (Exception ex)
{
results.header.ErrorMessage = ex.Message.ToString();
BAL.Common.LogManager.LogError("Register User", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(results);
}
public objResponse ChangeUserStatus(long User_ID_Auto_Pk)
{
objResponse Response = new objResponse();
try
{
SqlParameter[] sqlParameter = new SqlParameter[1];
sqlParameter[0] = new SqlParameter("@User_ID_Auto_Pk", SqlDbType.BigInt, 10);
sqlParameter[0].Value = Convert.ToInt64(User_ID_Auto_Pk);
DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_changeUserStatus", 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.ErrorMessage = ex.Message.ToString();
BAL.Common.LogManager.LogError("ChangeUserStatus", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(Response);
}
public ActionResult SaveSalesRep(string srcId, string srpId)
{
objResponse Response = new objResponse();
RoundRobinModel objRRSet = new RoundRobinModel();
try
{
objSourceManager.LinkSource(Convert.ToInt64(srcId), Convert.ToInt64(srpId));
if (Response.ErrorCode == 0)
{
objRRSet.source = objSourceManager.GetAllSource();
objRRSet.salesRep = objUserManager.GetUsers();
return(View("tempSetings", objRRSet));
}
else
{
return(Json("", JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
BAL.Common.LogManager.LogError("SaveSalesRep Post Method", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
return(Json("", JsonRequestBehavior.AllowGet));
}
}
public ActionResult AjaxAssignLead(string Lead_ID, string User_ID)
{
objResponse Response = new objResponse();
session = new Common.SessionHelper();
LeadsModel model = new LeadsModel();
try
{
string[] Lead_ID_PK = Lead_ID.Split(',');
for (int i = 1; i < Lead_ID_PK.Length; i++)
{
if (Lead_ID_PK[i].ToString() != "")
{
Response = objLeadsManager.AssignLead(Convert.ToInt64(Lead_ID_PK[i]), Convert.ToInt64(User_ID), Convert.ToInt64(session.UserSession.PIN));
if (Response.ErrorCode != 0)
{
break;
}
}
}
model.leads = objLeadsManager.getNewLeads(Convert.ToInt64(session.UserSession.PIN), Convert.ToInt64(session.UserSession.UserId), session.UserSession.UserType);
return(View("NewLeads", model));
}
catch (Exception ex)
{
BAL.Common.LogManager.LogError("AjaxAssignLead Contro", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
return(Json("", JsonRequestBehavior.AllowGet));
}
}
public async Task <ActionResult> GetTotalNotification()
{
session = new SessionHelper();
objResponse Response = new objResponse();
try
{
if (session.NotificationSession == null)
{
return(Json("", JsonRequestBehavior.AllowGet));
}
else
{
string lastSync = session.NotificationSession.lastNotificationAt;
session.NotificationSession.lastNotificationAt = DateTime.Now.ToString();
//session.NotificationSession.lastNotificationAt = DateTime.Now.ToString();
Response = objnfmanager.GetNewNotification(Convert.ToDateTime(lastSync), Convert.ToInt64(session.UserSession.PIN), session.UserSession.UserId);
session.NotificationSession.totalNoOfNotification = session.NotificationSession.totalNoOfNotification + Convert.ToInt32(Response.ErrorMessage);
return(Json(session.NotificationSession.totalNoOfNotification, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
BAL.Common.LogManager.LogError("GetTotalNotification Method", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
return(Json("", JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetEventInfo(string EventId)
{
objResponse Response = new objResponse();
Response = objCalender.GetEventInfo(Convert.ToInt32(EventId));
List <string> temp1 = new List <string>();
List <string> temp2 = new List <string>();
EventModel objModel = new EventModel();
objModel.RelatedToName = Response.ResponseData.Tables[0].Rows[0]["Name"].ToString();
objModel.Relation_ID_Fk = Convert.ToString(Response.ResponseData.Tables[0].Rows[0]["Relation_ID_FK"]);
objModel.RelationType = Convert.ToString(Response.ResponseData.Tables[0].Rows[0]["Relation_Type"]);
objModel.RelatedToContact = Response.ResponseData.Tables[0].Rows[0]["Mobile"].ToString();
objModel.RelatedToEmail = Response.ResponseData.Tables[0].Rows[0]["BusinessEmaol"].ToString();
objModel.colour = Response.ResponseData.Tables[0].Rows[0]["Colour"].ToString();
string LeadEventStart = Convert.ToDateTime(Response.ResponseData.Tables[0].Rows[0]["StartDate"]).ToString("MM/dd/yyyy hh:mm tt");
temp1 = LeadEventStart.Split(' ').ToList();
objModel.EventStartDate = temp1[0];
objModel.EventStartTime = temp1[1] + " " + temp1[2];
string LeadEventEnd = Convert.ToDateTime(Response.ResponseData.Tables[0].Rows[0]["EndDate"]).AddDays(-1).ToString("MM/dd/yyyy hh:mm tt");
temp2 = LeadEventEnd.Split(' ').ToList();
objModel.EventEndDate = temp2[0];
objModel.EventEndTime = temp2[1] + " " + temp2[2];
return(Json(objModel, JsonRequestBehavior.AllowGet));
}
public ActionResult AjaxUpdateRoles(RolesModel objModel)
{
objResponse Response = new objResponse();
UserRoles objRoles = new UserRoles();
RolesModel objRolesModel = new RolesModel();
try
{
objRoles = objJavaScriptSerializer.Deserialize <Project.Entity.UserRoles>(objJavaScriptSerializer.Serialize(objModel));
Response = objRoleManager.UpdateRole(objRoles);
if (Response.ErrorCode == 0)
{
objRolesModel.roles = objRoleManager.GetAllRoles();
return(View("AjaxManageRoles", objRolesModel));
}
else
{
return(Json("", JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
BAL.Common.LogManager.LogError("AjaxUpdateRoles Post Method", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
return(Json("", JsonRequestBehavior.AllowGet));
}
}
public static objResponse getPricingTemplateData(string pType)
{
objResponse Response = new objResponse();
try
{
SqlParameter[] sqlParameter = new SqlParameter[1];
sqlParameter[0] = new SqlParameter("@pType", SqlDbType.NVarChar, 50);
sqlParameter[0].Value = pType;
DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_getPricingTemplateData", 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("getPricingTemplateData", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(Response);
}
public ActionResult AjaxAddTask(string Titele, string StartDate, string EndDate, string StartTime, string EndTime, string RelateTo, string Description, string RemindMe, string Hours, string Minutes, string AssignTo)
{
objResponse Response = new objResponse();
session = new SessionHelper();
LeadModel objModel = new LeadModel();
try
{
if (AssignTo == "" || AssignTo == null)
{
AssignTo = session.UserSession.UserId.ToString();
}
Response = objTaskManager.AddTask(Titele, BAL.Helper.Helper.ConvertToDateNullable(StartDate + " " + StartTime, "dd/MM/yyyy HH:mm"), BAL.Helper.Helper.ConvertToDateNullable(StartDate + " " + StartTime, "dd/MM/yyyy HH:mm"), Convert.ToInt64(RelateTo), Description, RemindMe, Hours, Minutes, "Planed", AssignTo, session.UserSession.UserId);
if (Response.ErrorCode == 0)
{
//objModel.Task = UtilityManager.getTasksByRelateToID(Convert.ToInt64(RelateTo), session.UserSession.UserType, session.UserSession.UserId);
//return View(objModel);
return(Json("Success", JsonRequestBehavior.AllowGet));
}
else
{
return(Json("Fail", JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
BAL.Common.LogManager.LogError("AjaxAddTask conto Method", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
return(Json("Fail", JsonRequestBehavior.AllowGet));
}
}
public static objResponse getSmsTemplate(long rID, string dispId)
{
objResponse Response = new objResponse();
try
{
SqlParameter[] sqlParameter = new SqlParameter[2];
sqlParameter[0] = new SqlParameter("@rID", SqlDbType.BigInt, 30);
sqlParameter[0].Value = rID;
sqlParameter[1] = new SqlParameter("@dispId", SqlDbType.BigInt, 30);
sqlParameter[1].Value = Convert.ToInt64(dispId);
DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_getSmsTemplate", sqlParameter, DB_CONSTANTS.ConnectionString_ICS);
if (Response.ResponseData.Tables[0].Rows.Count > 0)
{
Response.ErrorCode = 0;
}
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("getSmsTemplate", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(Response);
}
public static objResponse getInvitedusersForActivation()
{
objResponse Response = new objResponse();
try
{
DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_GetInvitedUsersForActivation", 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("getInvitedusersForActivation", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(Response);
}
public static List <TextValue> GetGroupsForDropDown()
{
objResponse Response = new objResponse();
List <TextValue> group = new List <TextValue>();
try
{
DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_GetGroupsForDropDown", DB_CONSTANTS.ConnectionString_ICS);
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["Group_ID"].ToString();
objText.Text = dr["Group_Name"].ToString();
group.Add(objText);
}
}
}
catch (Exception ex)
{
Response.ErrorCode = 2001;
BAL.Common.LogManager.LogError("GetSourceForDropDown", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(group);
}
public static List <TextValue> GetUsersForDropDown()
{
objResponse Response = new objResponse();
List <TextValue> source = new List <TextValue>();
try
{
//SqlParameter[] sqlParameter = new SqlParameter[1];
//sqlParameter[0] = new SqlParameter("@Group_ID", SqlDbType.BigInt, 10);
//sqlParameter[0].Value = Group_ID;
DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_GetUsersForDropDown", DB_CONSTANTS.ConnectionString_ICS);
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["User_ID_Auto_PK"].ToString();
objText.Text = dr["UName"].ToString();
source.Add(objText);
}
}
}
catch (Exception ex)
{
Response.ErrorCode = 2001;
BAL.Common.LogManager.LogError("GetUsersForDropDown", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(source);
}
public ActionResult DeletePlans(string Plan_ID)
{
objResponse Response = new objResponse();
try
{
Response = objSubscriptionManager.DeletePlan(Convert.ToInt64(Plan_ID));
if (Response.ErrorCode == 0)
{
var planService = new StripePlanService();
planService.Delete(Plan_ID);
PlanModel objPlanModel = new PlanModel();
objPlanModel.plans = objSubscriptionManager.GetPlans();
return(View("AjaxAddPlan", objPlanModel));
}
else
{
return(Json("", JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
BAL.Common.LogManager.LogError("DeletePlan Post method", 1, Convert.ToString(ex.Source), Convert.ToString(ex.StackTrace), Convert.ToString(ex.Message));
return(Json("", JsonRequestBehavior.AllowGet));
}
}
public ActionResult DeleteDropListOption(string OptionID, string Module, string DropListName)
{
objResponse Response = new objResponse();
session = new SessionHelper();
DropDownModel objModel = new DropDownModel();
try
{
string Result = objSetingManager.DeleteDropListOption(Convert.ToInt64(OptionID), Module, DropListName, Convert.ToInt64(session.UserSession.PIN));
if (Result == "1")
{
objModel.options = objSetingManager.GetDropDownListing(Module, DropListName, Convert.ToInt64(session.UserSession.PIN));
return(View("TempData", objModel));
}
else
{
return(Json("", JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
BAL.Common.LogManager.LogError("DeleteDropListOptio Conto", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
return(Json("", JsonRequestBehavior.AllowGet));
}
}
public ActionResult AjaxUpdate(EstimateModel objEstimatemodel, string TextField)
{
objResponse Response = new objResponse();
Project.Entity.Estimate objEstimate = new Entity.Estimate();
session = new SessionHelper();
try
{
if (objEstimatemodel.Date != null)
{
objEstimate.Date = BAL.Helper.Helper.ConvertToDateNullable(objEstimatemodel.Date, "dd/MM/yyyy");
}
objEstimate.Estimate_ID_Auto_PK = objEstimatemodel.Estimate_ID;
objEstimate.Language = objEstimatemodel.Language;
objEstimate.AssignTo = objEstimatemodel.AssignTo;
objEstimate.Priority = objEstimatemodel.Priority;
objEstimate.Requirment = objEstimatemodel.Requirment;
Response = objEstimateManager.UpdateEstimate(objEstimate, session.UserSession.Username, TextField);
if (Response.ErrorCode == 0)
{
return(Json("Success", JsonRequestBehavior.AllowGet));
}
else
{
return(Json("Fail", JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
BAL.Common.LogManager.LogError("AjaxUpdate Post Method", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
return(Json("Fail", JsonRequestBehavior.AllowGet));
}
}
public ActionResult ContactPermissionCallback()
{
GooglePlusAccessToken objToken = new GooglePlusAccessToken();
objResponse Response = new objResponse();
DataSyncManager objData = new DataSyncManager();
session = new SessionHelper();
try
{
if (Request.QueryString["code"] != null)
{
objToken = GetAccessToken(Request.QueryString["code"].ToString());
Response = objData.SetGContactSeting(objToken.access_token, objToken.token_type, objToken.expires_in, objToken.refresh_token, "contact", Convert.ToInt64(session.UserSession.PIN), session.UserSession.UserId);
if (Response.ErrorCode == 0)
{
return(RedirectToRoute("UserSetings"));
}
else
{
return(RedirectToRoute("UserSetings"));
}
}
else
{
return(RedirectToRoute("UserSetings"));
}
}
catch (Exception ex)
{
BAL.Common.LogManager.LogError("ContactPermissionCallback Post Method", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
return(RedirectToRoute("UserSetings"));
}
}
public ActionResult AjaxChangeStatus(string EstimateID, string status, string Note)
{
session = new SessionHelper();
objResponse Response = new objResponse();
try
{
//DateTime FollowUp = BAL.Helper.Helper.ConvertToDateNullable(DateTime.Now.ToString(), "dd/MM/yyyy");
Response = objEstimateManager.ChangeStatus(Convert.ToInt64(EstimateID), status, Note, DateTime.Now, session.UserSession.UserId, session.UserSession.Username);
if (Response.ErrorCode == 0)
{
return(Json("success", JsonRequestBehavior.AllowGet));
}
else
{
return(Json("fail", JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
ViewBag.Error_Msg = ex.Message.ToString();;
BAL.Common.LogManager.LogError("UpdateLeadDetils Contro", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
return(Json("fail", JsonRequestBehavior.AllowGet));
}
}
public async Task <ActionResult> GetTaskAssignToNotification()
{
objResponse Response = new objResponse();
session = new SessionHelper();
try
{
Response = objnfmanager.GetNoOfTaskAssigned(Convert.ToDateTime(session.NotificationSession.lastNotificationViewedAt), Convert.ToInt64(session.UserSession.PIN), session.UserSession.UserId);
if (Response.ErrorCode == 0)
{
session.NotificationSession.totalNoOfNotification = session.NotificationSession.totalNoOfNotification + Convert.ToInt32(Response.ErrorMessage);
session.NotificationSession.lastTaskAssignToNf = DateTime.Now.ToString();
return(Json(Response.ErrorMessage, JsonRequestBehavior.AllowGet));
}
else
{
return(Json("", JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
BAL.Common.LogManager.LogError("GetTaskAssignToNotification Method", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
return(Json("", JsonRequestBehavior.AllowGet));
}
}
public JsonResult UpdateEvntDate(string EventID, string StartDate, string EndDate)
{
objResponse Response = new objResponse();
session = new SessionHelper();
try
{
DateTime fromDate = Convert.ToDateTime(StartDate);
//DateTime toDate = Convert.ToDateTime(EndDate).AddDays(-1);
DateTime toDate = Convert.ToDateTime(EndDate);
Response = Response = objCalender.UpdateEventDate(Convert.ToInt32(EventID), fromDate, toDate);
if (Response.ErrorCode == 0)
{
return(Json("1", JsonRequestBehavior.AllowGet));
}
else
{
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
BAL.Common.LogManager.LogError("UpdateEvntDate conto Method", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
public objResponse GetDbaByLeadId(long rId)
{
objResponse Response = new objResponse();
try
{
SqlParameter[] sqlParameter = new SqlParameter[1];
sqlParameter[0] = new SqlParameter("@rId", SqlDbType.BigInt, 10);
sqlParameter[0].Value = rId;
DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_GetDBaByLeadId", 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("GetDbaByLeadId", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(Response);
}
public JsonResult SaveEvent(string Title, string StartDate, string EndDate, string RelatedLead, string Description)
{
objResponse Response = new objResponse();
session = new SessionHelper();
try
{
DateTime fromDate = Convert.ToDateTime(StartDate);
// DateTime toDate = Convert.ToDateTime(EndDate).AddDays(-1);
DateTime toDate = Convert.ToDateTime(EndDate);
// Response = Response = objCalender.AddNewEvent(Title, BAL.Helper.Helper.ConvertToDateNullable(StartDate, "YYYY/MM/DD hh:mm a"), BAL.Helper.Helper.ConvertToDateNullable(StartDate, "YYYY/MM/DD hh:mm a"), EventColor,Description);
Response = Response = objCalender.AddNewEvent(Title, fromDate, toDate, RelatedLead, Description, session.UserSession.UserId);
//Response = Response = objCalender.AddNewEvent(Title, StartDate, EndDate, RelatedLead, Description, session.UserSession.UserId);
if (Response.ErrorCode == 0)
{
return(Json("1", JsonRequestBehavior.AllowGet));
}
else
{
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
BAL.Common.LogManager.LogError("SaveEvent conto Method", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
public bool shootEmail(long recieverId)
{
DripEmailModel objdripEmail = new DripEmailModel();
objResponse Response = new objResponse();
try
{
Response = UtilityManager.getEmailTemplate(recieverId);
string mailBody = PopulateBody(Response.ResponseData.Tables[0].Rows[0][0].ToString(), Response.ResponseData.Tables[1].Rows[0][1].ToString(), ConfigurationManager.AppSettings["mailTemplatedir"].ToString());
string toEmail = Response.ResponseData.Tables[1].Rows[0][0].ToString();
if (Helper.SendEmail(toEmail, "ICS", mailBody))
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
}
public JsonResult GetEventInfo(string EventId)
{
objResponse Response = new objResponse();
Response = objCalender.GetEventInfo(Convert.ToInt32(EventId));
List <string> temp1 = new List <string>();
List <string> temp2 = new List <string>();
LeadModel objModel = new LeadModel();
objModel.DBA = Response.ResponseData.Tables[0].Rows[0]["DBA"].ToString();
objModel.ContName = Response.ResponseData.Tables[0].Rows[0]["ContactName"].ToString();
objModel.bPhone = Response.ResponseData.Tables[0].Rows[0]["BusinessPhone"].ToString();
objModel.Email = Response.ResponseData.Tables[0].Rows[0]["Email"].ToString();
string LeadEventStart = Convert.ToDateTime(Response.ResponseData.Tables[0].Rows[0]["event_start"]).ToString("MM/dd/yy hh:mm tt");
temp1 = LeadEventStart.Split(' ').ToList();
objModel.LeadEventStartDate = temp1[0];
objModel.LeadEventStartTime = temp1[1] + " " + temp1[2];
//string LeadEventEnd = Convert.ToDateTime(Response.ResponseData.Tables[0].Rows[0]["event_end"]).AddDays(-1).ToString("MM/dd/yyyy hh:mm tt");
string LeadEventEnd = Convert.ToDateTime(Response.ResponseData.Tables[0].Rows[0]["event_end"]).ToString("MM/dd/yy hh:mm tt");
temp2 = LeadEventEnd.Split(' ').ToList();
objModel.LeadEventEndDate = temp2[0];
objModel.LeadEventEndTime = temp2[1] + " " + temp2[2];
return(Json(objModel, JsonRequestBehavior.AllowGet));
}
public string DeleteLead(Int64 Lead_id_pk)
{
objResponse response = new objResponse();
DataTable dt = new DataTable();
string result = "";
try
{
SqlParameter[] sqlParameter = new SqlParameter[1];
sqlParameter[0] = new SqlParameter("@Lead_id_pk", SqlDbType.BigInt, 0);
sqlParameter[0].Value = Lead_id_pk;
DATA_ACCESS_LAYER.Fill(response.ResponseData, "usp_DeleteLead", sqlParameter, DB_CONSTANTS.ConnectionString_ICS);
dt = response.ResponseData.Tables[0];
if (dt.Rows.Count > 0)
{
response.ErrorCode = 0;
response.ErrorMessage = "Success";
result = Convert.ToString(dt.Rows[0][0]);
}
}
catch (Exception ex)
{
response.ErrorCode = 2001;
response.ErrorMessage = "Error while processing: " + ex.Message;
BAL.Common.LogManager.LogError("DeleteLead", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(result);
}
public ForgotPasswordResponse resetPassword(string Email)
{
objResponse Response = new objResponse();
ForgotPasswordResponse results = new ForgotPasswordResponse();
try
{
using (var client = new HttpClient())
{
client.BaseAddress = new Uri("http://zmetricsapi.cruzata.com/auth/resetpassword");
//HTTP POST
var postTask = client.PostAsJsonAsync <string>("resetpassword", Email);
postTask.Wait();
var result = postTask.Result;
if (result.IsSuccessStatusCode)
{
var readTask = result.Content.ReadAsAsync <ForgotPasswordResponse>();
readTask.Wait();
results = readTask.Result;
}
}
}
catch (Exception ex)
{
results.header.ErrorMessage = ex.Message.ToString();
BAL.Common.LogManager.LogError("validate User", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(results);
}
public static List <TextValue> GetSourceForDropDown(long PIN)
{
objResponse Response = new objResponse();
List <TextValue> Category = 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, "usp_GetSourceForDropDown", sqlParameter, DB_CONSTANTS.ConnectionString_ICS);
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["Source_Val"].ToString();
objText.Text = dr["Source_Text"].ToString();
Category.Add(objText);
}
}
}
catch (Exception ex)
{
Response.ErrorCode = 2001;
BAL.Common.LogManager.LogError("GetSourceForDropDown", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(Category);
}
public ActionResult ViewOpportunity(string sessionid, string Opportunityid)
{
objResponse Response = new objResponse();
OpportunityModel objOpportunity = new OpportunityModel();
TaskManager objTaskManager = new TaskManager();
DocumentManager objDocManager = new DocumentManager();
NoteManager objNoteManager = new NoteManager();
EventManager objEventManager = new EventManager();
session = new SessionHelper();
UserManager objUserManager = new UserManager();
List <Users> UserList = new List <Users>();
UserList = objUserManager.GetUsers(session.UserSession.PIN);
try
{
Response = objOpportunityManager.ViewOpportunities(Convert.ToInt64(session.UserSession.PIN), Convert.ToInt64(Opportunityid));
if (Response.ErrorCode == 0)
{
objOpportunity.Opportunity_ID = Convert.ToInt64(Response.ResponseData.Tables[0].Rows[0]["Opportunity_ID_Auto_PK"]);
objOpportunity.Name = Response.ResponseData.Tables[0].Rows[0]["Name"].ToString();
objOpportunity.Amount = Response.ResponseData.Tables[0].Rows[0]["Amount"].ToString();
objOpportunity.RelateTo_Name = Response.ResponseData.Tables[0].Rows[0]["RealtedTo"].ToString();
objOpportunity.RealateTo_ID = Convert.ToInt64(Response.ResponseData.Tables[0].Rows[0]["Relate_To_ID_FK"]);
objOpportunity.RelateTo_ContactNo = Response.ResponseData.Tables[0].Rows[0]["RelateToContactNo"].ToString();
objOpportunity.RelateTo_Email = Response.ResponseData.Tables[0].Rows[0]["RelateToContactEmail"].ToString();
objOpportunity.Stage = Response.ResponseData.Tables[0].Rows[0]["Stage"].ToString();
objOpportunity.Type = Response.ResponseData.Tables[0].Rows[0]["Type"].ToString();
objOpportunity.Probability = Response.ResponseData.Tables[0].Rows[0]["Probability"].ToString();
objOpportunity.AssignTO_ID = Convert.ToInt64(Response.ResponseData.Tables[0].Rows[0]["AssignTo"]);
objOpportunity.AssignTO_Name = Response.ResponseData.Tables[0].Rows[0]["AssignToName"].ToString();
objOpportunity.Description = Response.ResponseData.Tables[0].Rows[0]["Description"].ToString();
objOpportunity.Source = Response.ResponseData.Tables[0].Rows[0]["Source"].ToString();
objOpportunity.Opportunity_Owner = Convert.ToInt64(Response.ResponseData.Tables[0].Rows[0]["CreatedBy"]);
objOpportunity.Opportunity_Owner_Name = Response.ResponseData.Tables[0].Rows[0]["OwnerName"].ToString();
objOpportunity.events = objEventManager.getEventsByRelateToID(Convert.ToInt64(session.UserSession.PIN), session.UserSession.UserId, Convert.ToInt64(Opportunityid), "OPPORTUNITY");
objOpportunity.activities = UtilityManager.getActivityByRelateToID(Convert.ToInt64(session.UserSession.PIN), Convert.ToInt64(Opportunityid), "OPPORTUNITY");
objOpportunity.tasks = objTaskManager.getTasksByRelateToID(Convert.ToInt64(session.UserSession.PIN), Convert.ToInt64(Opportunityid), session.UserSession.UserId, "OPPORTUNITY");
objOpportunity.docs = objDocManager.getDocsRelatedToID(Convert.ToInt64(session.UserSession.PIN), Convert.ToInt64(Opportunityid), "OPPORTUNITY", session.UserSession.UserId);
objOpportunity.notes = objNoteManager.getNotesByRelateToID(Convert.ToInt64(session.UserSession.PIN), Convert.ToInt64(Opportunityid), session.UserSession.UserId, "OPPORTUNITY");
ViewBag.Users = UserList;
return(View(objOpportunity));
}
else
{
ViewBag.Users = UserList;
return(View(objOpportunity));
}
}
catch (Exception ex)
{
ViewBag.Users = UserList;
BAL.Common.LogManager.LogError("ViewOpportunity", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
return(View(objOpportunity));
}
}
public objResponse UpdateProject(Project.Entity.Projects objProjects, string LogedUser, string Field)
{
objResponse Response = new objResponse();
try
{
SqlParameter[] sqlParameter = new SqlParameter[9];
sqlParameter[0] = new SqlParameter("@Date", SqlDbType.Date, 50);
sqlParameter[0].Value = objProjects.Date;
sqlParameter[1] = new SqlParameter("@Title", SqlDbType.NVarChar, 200);
sqlParameter[1].Value = objProjects.Title;
sqlParameter[2] = new SqlParameter("@Client_ID", SqlDbType.BigInt, 10);
sqlParameter[2].Value = objProjects.Client_ID;
sqlParameter[3] = new SqlParameter("@Model", SqlDbType.NVarChar, 30);
sqlParameter[3].Value = objProjects.Model;
sqlParameter[4] = new SqlParameter("@Category_ID", SqlDbType.BigInt, 10);
sqlParameter[4].Value = objProjects.Category_ID;
sqlParameter[5] = new SqlParameter("@CreatedBy", SqlDbType.NVarChar, 60);
sqlParameter[5].Value = LogedUser;
sqlParameter[6] = new SqlParameter("@CreatedDate", SqlDbType.DateTime, 50);
sqlParameter[6].Value = DateTime.Now;
sqlParameter[7] = new SqlParameter("@Project_ID_PK", SqlDbType.BigInt, 10);
sqlParameter[7].Value = objProjects.Project_ID_PK;
sqlParameter[8] = new SqlParameter("@Field", SqlDbType.NVarChar, 100);
sqlParameter[8].Value = Field;
DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_UpdateEProject", 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("UpdateProject", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(Response);
}
