private static List <DeltoneCRM_DAL.CompanyDAL.CompanyView> GetEventListCompany(string month, string yearV)
{
var listCompany = new List <DeltoneCRM_DAL.CompanyDAL.CompanyView>();
var conn = ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString;
var reminderList = new CalendarEventDAL(conn).GetAllCAllBackEvents();
var monthtype = month;
var year = yearV;
reminderList = GetAllCurrentMonthValid(reminderList, monthtype, year);
if (reminderList.Count() > 0)
{
foreach (var item in reminderList)
{
if (item.companyId != "0")
{
var comView = new DeltoneCRM_DAL.CompanyDAL.CompanyView();
comView.CompanyID = Convert.ToInt32(item.companyId);
listCompany.Add(comView);
}
}
}
return(listCompany);
}
private string EventSelectedByCompanyEventId(int eveID)
{
var dateEventstarted = "";
string cs = ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString;
var selectedEve = new CalendarEventDAL(cs).getEvents(eveID);
if (selectedEve.Count() > 0)
{
var contactStr = "";
var comId = Convert.ToInt32(selectedEve[0].companyId.ToString());
if (comId > 0)
{
var conId = GetContacts(comId.ToString());
contactStr = PopulateContact(conId);
}
var desc = Regex.Replace(selectedEve[0].description.Trim(), @"\t|\n|\r", "");
dateEventstarted = selectedEve[0].id.ToString() + "#rr#"
+ selectedEve[0].title.Trim() + "#rr#"
+ desc + "#rr#"
+ selectedEve[0].start + "#rr#"
+ selectedEve[0].end + "#rr#"
+ selectedEve[0].allDay + "#rr#"
+ selectedEve[0].color + "#rr#"
+ selectedEve[0].url + "#rr#"
+ selectedEve[0].createdDate + "#rr#"
+ selectedEve[0].modifiedDate + "#rr#"
+ selectedEve[0].start.ToString("yyyy-MM-dd") + "#rr#"
+ comId + "," + contactStr;
}
return(dateEventstarted);
}
protected string GetCAllBackEvents(string monthtype, string year)
{
String strOutput = "{\"aaData\":[";
using (SqlConnection conn = new SqlConnection())
{
var connStr = ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString;
var reminderList = new CalendarEventDAL(connStr).GetAllCAllBackEvents();
reminderList = GetAllCurrentMonthValid(reminderList, monthtype, year);
if (reminderList.Count() > 0)
{
foreach (var item in reminderList)
{
if (item.companyId != "0")
{
var viewCom = "<img src='../Images/Edit.png' onclick='ViewCom(" + item.companyId + ")'/>";
var comId = item.companyId;
var fillCom = FillCompanyContactObj(comId);
var CoName = fillCom.CoName;
var contactName = fillCom.contactName;
var telephone = fillCom.telephone;
var mobile = fillCom.mobile;
var view = item.url;
var dexc = Regex.Replace(item.description.ToString(), @"\t|\n|\r", "");
dexc = dexc.Replace(@"\", "-");
dexc = dexc.Replace("\"", "");
var message = item.start.Date.ToShortDateString() + " --> " + dexc;
strOutput = strOutput + "[\"" + comId + "\"," + "\"" + CoName + "\","
+ "\"" + contactName + "\","
+ "\"" + telephone + "\","
+ "\"" + mobile + "\","
+ "\"" + message + "\","
+ "\"" + viewCom + "\"],";
}
}
int Length = strOutput.Length;
strOutput = strOutput.Substring(0, (Length - 1));
}
strOutput = strOutput + "]}";
}
return(strOutput);
}
