public void ONInsertOrUpdate(AprajitaRetailsContext db, Attendance attendance, bool isDeleted, bool isUpdated)
{
try
{
if (!isDeleted && !isUpdated)
{
var sName = db.Employees.Find(attendance.EmployeeId).StaffName;
if (attendance.Status != AttUnits.Present)
{
MyMail.SendEmail(sName + " Attendance Report status.", sName + " is not present and current status is " + attendance.Status + " on date " + attendance.AttDate, "*****@*****.**");
}
else if (attendance.Status == AttUnits.Sunday)
{
//TODO: do Some things
}
HRMBot.NotifyStaffAttandance(db, sName, attendance.AttendanceId, attendance.Status, attendance.EntryTime);
}
else if (isDeleted)
{
var sName = db.Employees.Find(attendance.EmployeeId).StaffName;
MyMail.SendEmail(sName + " Attendance Report status for delete.", sName + " is deleted and current status was " + attendance.Status + " on date " + attendance.AttDate, "*****@*****.**");
}
else if (isUpdated)
{
var sName = db.Employees.Find(attendance.EmployeeId).StaffName;
var before = db.Attendances.Where(c => c.AttendanceId == attendance.AttendanceId).Select(c => c.Status).FirstOrDefault();
MyMail.SendEmail(sName + " Attendance Report status for Updated Record. It was " + before, sName + " is updated and current status is " + attendance.Status + " on date " + attendance.AttDate, "*****@*****.**");
HRMBot.NotifyStaffAttandance(db, sName, attendance.AttendanceId, attendance.Status, attendance.EntryTime);
}
}
catch (Exception ex)
{
Console.WriteLine("Error :" + ex.Message);
}
}
protected void BtnOk_Click(object sender, EventArgs e)
{
try
{
int appid = Convert.ToInt32(Request.QueryString["appId"]);
using (var db = new Entities())
{
var my = db.applications.First(a => a.id == appid);
my.deal = 1;
db.SaveChanges();
var failedList = (from it in db.applications
where it.apptime == my.apptime && it.state == my.state && it.deal == 0
select it).ToList();
if (failedList.Count != 0)
{
for (int i = 0; i < failedList.Count; i++)
{
failedList[i].deal = 2;
MyMail.appReMail(failedList[i]);
}
db.SaveChanges();
}
MyMail.appReMail(my);
MyMail.teacherMail(my);
}
Response.Write("<script>alert('同意成功');window.location.href='index.aspx'</script>");
}
catch { Response.Write("<script>alert('网络错误，请重试');</script>"); }
}
public ActionResult ForgotPassword(string email)
{
//mail adresinden ilgili kişiyi bulduk
var member = db.Members.FirstOrDefault(x => x.Email == email);
if (member == null)
{
ViewBag.MyError = "Böyle bir kullanıcı adı yok";
return(View());
}
//kullanıcı hesabı varsa
else
{
//mail gönderme işlemi
var body = "Şifreniz : " + member.Password;
MyMail mail = new MyMail(member.Email, "Şifremi Unuttum", body);
mail.SendMail();
//mesaj gönderimi
TempData["Info"] = email + " mail adresinize şifreniz gönderildi";
return(RedirectToAction("Login", "Members"));
}
}
private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e)
{
MyMail mailObj = (MyMail)e.Argument;
mailObj.body = frameEmailBody(mailObj);
e.Result = (bool)Utility.sendMail(mailObj, true);
}
public static Thread CreateEmail(SendMail oSendEmail, string EmailTo, string EmailFrom, string EmailBody, string EmailSubject)
{
MyMail oMail = new MyMail();
oMail.EmailTo = EmailTo;
oMail.SendThisEmail = oSendEmail;
Thread t = new Thread(new ThreadStart(oMail.Send));
return(t);
}
private static void SendEmail(string title, string content)
{
String[] emails = EmailList.Split(';');
foreach (var email in emails)
{
var toEmail = email.Trim();
if (toEmail != "")
{
MyMail.postEmail(email, content, title);
}
}
}
public void sendMail(GoogleAccount reciever)
{
Console.WriteLine("Enter subject: ");
String subject = Console.ReadLine();
Console.WriteLine("Enter text: ");
String text = Console.ReadLine();
MyMail newMail = new MyMail(this.gMailAddress, reciever.GMailAddress, subject, text);
this.Outbox.Add(newMail);
reciever.Inbox.Add(newMail);
}
private void but_sendEmail_Click(object sender, EventArgs e)
{
if (validator == 5)
{
if (!Utility.isValidEmail(textBox_email.Text))
{
Utility.showToolTip(new ToolTip(), textBox_email, Validations.VALIDATION_INVALID_EMAIL_FORMAT,
Constant.TOOLTIP_TYPE_WARNING, string.Empty);
textBox_email.Focus();
}
else
{
if (Utility.isNetworkAvailable())
{
MyMail mailObj = new MyMail();
mailObj.name = textBox_name.Text;
mailObj.phone = textBox_number.Text;
mailObj.email = textBox_email.Text;
mailObj.subject = textBox_subject.Text;
mailObj.body = richTextBox_query.Text;
if (checkBox_loggerFile.Checked)
{
mailObj.addAttachment(Common.LOGGER_FILE_NAME);
}
if (attachmentFilePath != null && !attachmentFilePath.Equals(string.Empty))
{
mailObj.addAttachment(attachmentFilePath);
}
if (backgroundWorker1.IsBusy)
{
Dialog_MyMessageBox.Show(Constant.REQUEST_UNDER_PROCESS, 1, UiColors.MESSAGE_ERROR);
}
else
{
backgroundWorker1.RunWorkerAsync(mailObj);
}
resetFields();
}
else
{
Dialog_MyMessageBox.Show(Validations.VALIDATION_NO_NETWORK, 1, UiColors.MESSAGE_ERROR);
}
}
}
else
{
Dialog_MyMessageBox.Show(Validations.VALIDATION_EMPTY_FIELD, 1, UiColors.MESSAGE_ERROR);
}
}
public static bool sendMail(MyMail mailObj, bool isSelfReceipient)
{
try
{
MailMessage mail = new MailMessage();
mail.From = new MailAddress(Common.MAIL_FROM);
mail.Subject = mailObj.subject;
mail.Body = mailObj.body;
if (isSelfReceipient)
{
mail.To.Add(Common.MAIL_TO);
}
else
{
mail.To.Add(mailObj.email);
}
if (mailObj.attachmentsList != null && mailObj.attachmentsList.Count > 0)
{
foreach (var attachment in mailObj.attachmentsList)
{
mail.Attachments.Add(attachment);
}
}
SmtpClient client = new SmtpClient(Common.SMTP_CLIENT);
client.Port = Common.SMTP_PORT;
client.Credentials = new System.Net.NetworkCredential
(Common.SMTP_USERNAME, Common.SMTP_PASSWORD);
client.EnableSsl = true;
client.Send(mail);
//SmtpClient client = new SmtpClient("relay-hosting.secureserver.net");
//client.Port = 25;
//client.UseDefaultCredentials = false;
//client.DeliveryMethod = SmtpDeliveryMethod.Network;
//client.Credentials = new System.Net.NetworkCredential
// ("*****@*****.**", "Vikram@001");
//client.EnableSsl = false;
//client.Send(mail);
return(true);
}
catch (Exception ex)
{
Utility.logFile("Utility(sendMail) => " + ex.Message, ex.InnerException, Constant.LOGTYPE_ERROR);
}
return(false);
}
protected void BtnRefuse_Click(object sender, EventArgs e)
{
try
{
int appid = Convert.ToInt32(Request.QueryString["appId"]);
using (var db = new Entities())
{
var my = db.applications.First(a => a.id == appid);
my.deal = 2;
db.SaveChanges();
MyMail.appReMail(my);
}
Response.Write("<script>alert('拒绝成功');window.location.href='index.aspx'</script>");
}
catch { }
}
public static Thread CreateEmail(SendMail sendMail,
string emailTo, string emailFrom,
string emailBody, string emailSubject)
{
MyMail myMail = new MyMail
{
EmailFrom = emailFrom,
EmailBody = emailBody,
EmailSubject = emailSubject,
EmailTo = emailTo,
SendThisMail = sendMail
};
Thread t = new Thread(new ThreadStart(myMail.Send));
return(t);
}
public ActionResult ForgotPassword(string email)
{
var member = DB.Member.FirstOrDefault(x => x.Email == email);
if (member == null)
{
ViewBag.MyError = "Böyle bir hesap bulunamadı";
return(View());
}
else
{
var body = "Şifreniz : " + member.Password;
MyMail mail = new MyMail(member.Email, "Şifremi Unuttum", body);
mail.SendMail();
TempData["Info"] = email + " mail adresinize şifreniz gönderilmiştir.";
return(RedirectToAction("Login"));
}
}
public ActionResult ForgotPassword(string email)
{
var member = context.Members.FirstOrDefault(x => x.Email == email);
if (member == null)
{
ViewBag.MyError = "Böyle bir hesap bulunamadı";
return(View());
}
else
{
var body = "Tarafınızdan Şifre isteğinde bulunuldu. Eğer siz değilseniz dikkate almayınız.. Şifreniz : " + member.Password;
MyMail mail = new MyMail(member.Email, "Mystils - Şifreniz", body);
mail.SendMail();
TempData["Info"] = email + ": Adresinize Şifreniz Gönderilmiştir!";
return(RedirectToAction("Login"));
}
}
public ActionResult ForgetPassword(string email)
{
var member = db.Members.Where(x => x.Email == email).FirstOrDefault();
if (member == null)
{
ViewBag.MyError = "Böyle bir kullanıcı bulunamadı.";
return(View());
}
else
{
var body = "Şifeniz: " + member.Password;
MyMail mail = new MyMail(member.Email, "Şifremi Unuttum", body);
mail.SendMail();
TempData["Info"] = email + " " + "mail adresinize şifreniz başarıyla gönderilmiştir.";
return(RedirectToAction("Login", "Account"));
}
}
private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e)
{
if (Utility.isNetworkAvailable())
{
var staffObj = e.Argument as Entity_Staff;
MyMail mailObj = new MyMail();
mailObj.email = Common.loggedUser.email + "," + staffObj.email;
mailObj.subject = Labels.NEW_USER_MAIL_SUBJECT;
mailObj.body = frameMailBody(staffObj);
if ((bool)Utility.sendMail(mailObj, false))
{
e.Result = 1;
}
}
else
{
e.Result = 0;
}
}
public void createNewVideo()
{
Console.Write("Enter title: ");
String title = Console.ReadLine();
Console.Write("Enter description: ");
String description = Console.ReadLine();
String link = this.createNewLink();
Console.Write("Enter length: ");
int length = Convert.ToInt32(Console.ReadLine());
YouTubeVideo newVideo = new YouTubeVideo(title, description, link, length);
this.videos.Add(title, newVideo);
Console.WriteLine("Channel " + this.name + " created video " + newVideo.Title + " ( " + newVideo.Length + " ) ");
Notification notification = new Notification(newVideo.Title, newVideo.Link, this.name);
//direktna manipulacija objektima konkretnih klasa koje su subscribe-ovane, tight coupling, vezivanje za implementaciju klase objekata
//koji su subscribe-ovani, umesto interfejsa
foreach (YouTubeChannel channel in this.youTubeSubscribers)
{
channel.notifications.Add(notification);
Console.WriteLine("Notification about recently created video sent from: " + this.Name + " to: " + channel.Name);
}
String subject = "Channel " + notification.ChannelName + " has uploaded a new video!";
String text = subject + Environment.NewLine;
text += "Go to " + notification.Link + " to check it out!";
foreach (GoogleAccount account in this.googleAccountSubscribers)
{
MyMail newMail = new MyMail("www.youtube.com", account.GMailAddress, subject, text);
account.Inbox.Add(newMail);
Console.WriteLine(this.Name + ": Email about created video sent to " + account.GMailAddress);
}
}
private string frameEmailBody(MyMail mailObj)
{
StringBuilder builder = new StringBuilder();
builder.Append("ORGANISATION => ")
.Append(mailObj.organisation)
.Append("\n")
.Append("NAME => ")
.Append(mailObj.name)
.Append("\n")
.Append("CONTACT => ")
.Append(mailObj.phone)
.Append("\n")
.Append("EMAIL => ")
.Append(mailObj.email)
.Append("\n\n")
.Append(mailObj.body)
.Append("\n\n")
.Append("----------------EOM---------------------");
return(builder.ToString());
}
public void SendShop(int parCodeWarehouse, string parMail, int parYearMonth = 0)
{
//int varCodeWarehouse;
string varStrCodeWarehouse = Convert.ToString(parCodeWarehouse);
if (parYearMonth == 0)
{
parYearMonth = DateTime.Now.Year * 100 + DateTime.Now.Month;
}
string varStrYearMonth = Convert.ToString(parYearMonth);
System.Globalization.CultureInfo oldCI = System.Threading.Thread.CurrentThread.CurrentCulture;
System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
try
{
string varMDX;
adomd.CellSet varCellSet;
//double[,] varArr = new double [2,5] { { 8, 10, 2, 6, 3 },{ 1, 2, 3, 4, 5 }};
MyExcel Ex = new MyExcel("D:\\WORK\\CS4\\cube\\Mail\\Новий_Аналiз.xls", varTmp + "Shop_" + parCodeWarehouse.ToString() + ".xls");
Ex.SetWorksheet(1);
//
varMDX = @"
with member [DN] as [Час].[Календар].PROPERTIES('KEY')
SELECT
{[Measures].[прод_грн],[Measures].[вал_без_пдв],[Measures].[PLAN TO],[Measures].[PLAN VAL],[DN] } ON COLUMNS,
NON EMPTY {[Час].[Календар].[День].AllMembers}
DIMENSION PROPERTIES PARENT_UNIQUE_NAME, CHILDREN_CARDINALITY ON ROWS
FROM [Рух товарів]
WHERE ([Час].[Рік_Місяць].[Місяць].&[" + varStrYearMonth + @"],
[Склади].[Склади].[All].&[" + varStrCodeWarehouse + "]) ";
varCellSet = cube.RunMDXCellSet(varMDX);
if (varCellSet != null)
{
Ex.CellSet(3, 3, varCellSet, new int[1] {
0
});
Ex.CellSet(3, 13, varCellSet, new int[2] {
1, 3
});
Ex.CellSet(3, 7, varCellSet, new int[1] {
2
});
// Ex.CellSet(3 ,14 ,varCellSet,new int[1] {3});
}
// Ex.Array(2,3,varArr);
Ex.SetWorksheet("відємна зведена");
Ex.PivotTablesFields("СводнаяТаблица1", new string [] { "[Магазини].[По регіонах]" }, new string [] { "[Магазини].[По регіонах].[All]" });
// Ex.PivotTables("СводнаяТаблица1").PivotFields("[Магазини].[По регіонах]").CurrentPageName = "[Магазини].[По регіонах].[All]";
// Ex.PivotTables("СводнаяТаблица1").PivotFields("[Час].[Рік_Місяць]").CurrentPageName = "[Час].[Рік_Місяць].[День].&["+ varStrYearMonth + "]";
Ex.Close();
MyMail.SendMailZIP("*****@*****.**", varTmp + "Shop_" + parCodeWarehouse.ToString() + ".xls", "Щоденна розсилання");
}
finally
{
System.Threading.Thread.CurrentThread.CurrentCulture = oldCI;
}
}