public List <NoteTable> getDocumentsFromErrorNo(string errorNo)
{
inanSoftDBEntities1 db = new inanSoftDBEntities1();
var documentList = db.NoteTable.Where(x => x.ErrorNo == errorNo).ToList();
return(documentList);
}
public ActionResult CheckUser(string email, string pass)
{
inanSoftDBEntities1 db = new inanSoftDBEntities1();
var userModel = db.UserTable.Where(x => x.Email == email && x.Password == pass).FirstOrDefault(); // şuanki kullanıcı atanır
if (userModel == null)
{
return(View("Index"));
}
else
{
Session["UserModel"] = userModel;
writeLogFile(userModel);
BusinessClass business = new BusinessClass();
try
{
business.checkMondayAndSendReportWithMail();
}catch (Exception ex)
{
}
return(RedirectToAction("Index", "Admin"));
}
}
public List <ImagesTable> getImagesFromErrorNo(string errorNo)
{
inanSoftDBEntities1 db = new inanSoftDBEntities1();
var imagesList = db.ImagesTable.Where(x => x.ErrorNo == errorNo).ToList();
return(imagesList);
}
public void sendMailForSuperUser(string errorNo)
{
var userModel = common.getCurrentUserModel();
try
{
inanSoftDBEntities1 db = new inanSoftDBEntities1();
var superUsers = db.SuperUserTable.Where(x => x.Company == userModel.Company).FirstOrDefault().Users.Split(',');
List <MailAddress> teamMemberMailList = new List <MailAddress>();
var builder = new StringBuilder();
foreach (var member in superUsers)
{
teamMemberMailList.Add(new MailAddress(db.UserTable.Where(x => x.Name == member).FirstOrDefault().Email, member));
builder.AppendLine("Takım Üyesi: " + member + ",");
}
// sendMail For TeamLeader and TeamMembers
sendMail(
teamMemberMailList[0].Address,
superUsers[0],
teamMemberMailList,
"'" + errorNo + "' ",
" (" + errorNo + ") Numaralı Yeni Hata Eklendi"
);
}
catch (Exception ex)
{
}
}
public List <NotificationTable> getNotificationListForCurrentUser()
{
inanSoftDBEntities1 db = new inanSoftDBEntities1();
UserTable currentUserModel = getCurrentUserModel();
// o kullanıcıya atan bildirimleri çekelim !
var notificationList = db.NotificationTable.Where(x => x.MailAddress == currentUserModel.Email)
.OrderBy(x => x.IsRead).ToList();
return(notificationList);
}
// time reamaining-----------------------------
public double getTimeRemainingCount(string errorNo)
{
inanSoftDBEntities1 db = new inanSoftDBEntities1();
DateTime nowDate = DateTime.Now;
DateTime finishDate;
TimeSpan timeRemaining;
finishDate = Convert.ToDateTime(db.DFiveTable.Where(x => x.ErrorNo == errorNo).FirstOrDefault().Deadline);
timeRemaining = finishDate - nowDate;
double totalDay = timeRemaining.TotalDays;
return(totalDay);
}
//mesajlarda reddetme sebeplerini gösterelim
public List <DEightTable> getMessages()
{
inanSoftDBEntities1 db = new inanSoftDBEntities1();
var messageListDEightTable = new List <DEightTable>(); // DEight tablo listesi oluşturalım
foreach (var notif in getNotificationListForCurrentUser())
{
var dEightTable = new DEightTable();
// bildirimde gösterilen hata numarsına göre aynı hataya ait reddetme sebebi var ise mesaj olarak gösterilecektir
var message = db.DEightTable.Where(x => x.ErrorNo == notif.ErrorNo && x.RejectionReason != null).FirstOrDefault();
if (message != null)
{
messageListDEightTable.Add(message);
}
}
return(messageListDEightTable);
}
public void sendCompleteErrorMail(DOneTable dOneTable, string subject, string message)
{
inanSoftDBEntities1 db = new inanSoftDBEntities1();
List <MailAddress> teamMemberMailList = new List <MailAddress>();
var builder = new StringBuilder();
foreach (var member in dOneTable.TeamMembers.Split(','))
{
teamMemberMailList.Add(new MailAddress(db.UserTable.Where(x => x.Name == member).FirstOrDefault().Email, member));
builder.AppendLine("Takım Üyesi: " + member + ",");
}
// sendMail For TeamLeader and TeamMembers
sendMail(
db.UserTable.Where(x => x.Name == dOneTable.TeamLeader).FirstOrDefault().Email,
dOneTable.TeamLeader,
teamMemberMailList,
"'" + dOneTable.ErrorNo + "' " + subject,
message + " (Takım Lideri : " + dOneTable.TeamLeader + "," + builder.ToString() + ")"
);
}
public void sendMailToUserEditTeam(DOneTable dOneTable)
{
inanSoftDBEntities1 db = new inanSoftDBEntities1();
List <MailAddress> teamMemberMailList = new List <MailAddress>();
var builder = new StringBuilder();
foreach (var member in dOneTable.TeamMembers.Split(','))
{
teamMemberMailList.Add(new MailAddress(db.UserTable.Where(x => x.Name == member).FirstOrDefault().Email, member));
builder.AppendLine("Takım Üyesi: " + member + ",");
}
// sendMail For TeamLeader and TeamMembers
sendMail(
db.UserTable.Where(x => x.Name == dOneTable.TeamLeader).FirstOrDefault().Email,
dOneTable.TeamLeader,
teamMemberMailList,
"'" + dOneTable.ErrorNo + "'" + " Çözüm Ekibi Yeniden oluşturuldu",
"Takım Lideri : " + dOneTable.TeamLeader + "," + builder.ToString()
);
}
public void sendMailForAnyThing(string email, string subject, string message)
{
try
{
inanSoftDBEntities1 db = new inanSoftDBEntities1();
var thisUser = db.UserTable.Where(x => x.Email == email).FirstOrDefault();
var name = thisUser.Name;
List <MailAddress> teamMemberMailList = new List <MailAddress>();
teamMemberMailList.Add(new MailAddress(email));
sendMail(
teamMemberMailList[0].Address,
name,
teamMemberMailList,
subject,
message
);
}
catch (Exception ex)
{
}
}
