public List <StudentInfoObj> GetAllStudentInfo() { List <StudentInfoObj> studentinfolist = null; //Lets get the list of all employees in a datataable using (DataTable table = SqlDBHelper.ExecuteSelectCommand("GetStudentAll", CommandType.StoredProcedure)) { //check if any record exist or not if (table.Rows.Count > 0) { //Lets go ahead and create the list of employees studentinfolist = new List <StudentInfoObj>(); //Now lets populate the employee details into the list of employees foreach (DataRow row in table.Rows) { StudentInfoObj stuinfo = new StudentInfoObj(); stuinfo.Name = row["Name"].ToString(); stuinfo.ID = (row["ID"]).ToString(); stuinfo.Dept = row["Dept"].ToString(); stuinfo.Gender = Convert.ToChar(row["Gender"]); stuinfo.Completedcredit = Convert.ToInt32(row["CompletedCredit"]); stuinfo.Semester = Convert.ToInt32(row["Semester"]); stuinfo.Cgpa = float.Parse(row["Cgpa"].ToString()); stuinfo.Password = Convert.ToString(row["Password"]); studentinfolist.Add(stuinfo); } } } return(studentinfolist); }
public List <Daneshkade> GetAllDaneshkade() { List <Daneshkade> danlist = null; using (DataTable table = SqlDBHelper.ExecuteSelectCommand("[Resource_Control].[DaneshkadesSelectAll]", CommandType.StoredProcedure)) { if (table.Rows.Count > 0) { danlist = new List <Daneshkade>(); foreach (DataRow row in table.Rows) { Daneshkade danesh = new Daneshkade(); danesh.ID = Convert.ToInt32(row["ID"]); danesh.NameDanesh = row["namedanesh"] as string; danlist.Add(danesh); } } } return(danlist); }
private void SendHtmlFormattedEmail(string TicketId, string body) { dt = new DataTable(); //dt = objTicket.GetLeadEmails(Convert.ToInt32(lblTeam.Text)); using (MailMessage mailMessage = new MailMessage()) { SmtpClient smtp = new SmtpClient(); // mailMessage.From = new MailAddress("*****@*****.**"); mailMessage.From = new MailAddress("*****@*****.**"); mailMessage.To.Add(new MailAddress("*****@*****.**")); //mailMessage.To.Add(new MailAddress("*****@*****.**")); DataTable dtLocation = new DataTable(); dtLocation = objSqlDBHelper.ExecuteSelectCommand("SELECT top 1 dbo.RTM_Team_List.T_Location " + " FROM dbo.RTM_User_List INNER JOIN " + " dbo.RTM_Team_List ON dbo.RTM_User_List.UL_Team_Id = dbo.RTM_Team_List.T_ID " + " WHERE (dbo.RTM_User_List.UL_Employee_Id = '" + lblEmpId.Text + "')", CommandType.Text); if (dtLocation.Rows.Count > 0) { if (dtLocation.Rows[0][0].ToString() != "IND" & dtLocation.Rows[0][0].ToString() != "CHN") { mailMessage.To.Add(new MailAddress("*****@*****.**")); } } if (string.IsNullOrEmpty(lblEmail.Text) == false) { mailMessage.CC.Add(new MailAddress(lblEmail.Text)); } //if (dt.Rows.Count > 0) //{ // foreach (DataRow dr in dt.Rows) // { // if (string.IsNullOrEmpty(dr["UL_EmailId"].ToString()) == false) // { // mailMessage.CC.Add(new MailAddress(dr["UL_EmailId"].ToString())); // } // } //} if (Session["access"].ToString() == "4") { if (string.IsNullOrEmpty(lblRptMgrEmail.Text.ToString().Trim()) == false) { mailMessage.CC.Add(new MailAddress(lblRptMgrEmail.Text.ToString().Trim())); } } if (ddlStatus.SelectedItem.Text == "Closed") { mailMessage.Subject = "RTM Tickets: Ticket # " + TicketId + " is Closed by user " + lblUser.Text; } else if (ddlStatus.SelectedItem.Text == "Re-Open") { mailMessage.Subject = "RTM Tickets: Ticket # " + TicketId + " is Re-Opened by user " + lblUser.Text; } else { mailMessage.Subject = "RTM Tickets: Ticket # " + TicketId + " is Modified by user " + lblUser.Text; } mailMessage.Body = body; mailMessage.IsBodyHtml = true; smtp.Port = 25; smtp.Host = "10.0.5.104"; //smtp.Host = "outlook-south.tangoe.com"; smtp.DeliveryMethod = SmtpDeliveryMethod.Network; smtp.EnableSsl = false; smtp.Send(mailMessage); } }