public string UpdateEssencialDecission(EmailInforType.EssencialDecissionType _Update) { MySqlCommand oSqlCommand = new MySqlCommand(); string sqlQuery = "Update ecoessencialdecission Set " + "SysID=@SysID," + "Department=@Department," + "FirstPerson=@FirstPerson," + "FirstEmail=@FirstEmail," + "SecondPeson=@SecondPeson," + "SeconfEmail=@SeconfEmail," + "Status=@Status" + " Where 1=1 " + " and SysID=@SysID"; try { oSqlCommand.Parameters.AddWithValue("@SysID", _Update.SysID); oSqlCommand.Parameters.AddWithValue("@Department", _Update.Department); oSqlCommand.Parameters.AddWithValue("@FirstPerson", _Update.FirstPerson); oSqlCommand.Parameters.AddWithValue("@SeconfEmail", _Update.SecondEmail); oSqlCommand.Parameters.AddWithValue("@FirstEmail", _Update.FirstEmail); oSqlCommand.Parameters.AddWithValue("@SecondPeson", _Update.SecondPeson); oSqlCommand.Parameters.AddWithValue("@Status", _Update.Status); string respond = Mycommon.ExicuteAnyCommand(sqlQuery, oSqlCommand, null, "Update eco email"); return(respond); } catch (Exception ex) { return(ex.Message); } }
public string GetExistEssencialDecission(int SysID, out EmailInforType.EssencialDecissionType _ExistData) { _ExistData = new EmailInforType.EssencialDecissionType(); MySqlCommand oSqlCommand = new MySqlCommand(); string sqlQuery = "Select " + "SysID," + "Department," + "FirstPerson," + "FirstEmail," + "SecondPeson," + "SeconfEmail," + "Status" + " from ecoessencialdecission" + " Where 1=1 and status=1 " + " and SysID=" + SysID; DataRow r = Mycommon.GetDataRow(sqlQuery, "get Email Data"); if (r != null) { try { bool resp = false; int inSysID = 0; resp = int.TryParse(r["SysID"].ToString(), out inSysID); _ExistData.SysID = inSysID; _ExistData.Department = r["Department"].ToString(); _ExistData.FirstPerson = r["FirstPerson"].ToString(); _ExistData.FirstEmail = r["FirstEmail"].ToString(); _ExistData.SecondPeson = r["SecondPeson"].ToString(); _ExistData.SecondEmail = r["SeconfEmail"].ToString(); int inStatus = 0; resp = int.TryParse(r["Status"].ToString(), out inStatus); _ExistData.Status = inStatus; return("True"); } catch (Exception ex) { return(ex.Message); } } else { return("data not found "); } }
public List <EmailInforType.EssencialDecissionType> GetEmailDecissionList() { List <EmailInforType.EssencialDecissionType> _EmailList = new List <EmailInforType.EssencialDecissionType>(); string sql1 = "Select SysID from ecoessencialdecission where status=1"; DataTable tb = new DataTable(); tb = Mycommon.GetDataTable(sql1, "Get Email List"); if (tb != null) { foreach (DataRow r in tb.Rows) { EmailInforType.EssencialDecissionType onemail = new EmailInforType.EssencialDecissionType(); string respond = GetExistEssencialDecission(int.Parse(r["Sysid"].ToString()), out onemail); if (respond == "True") { _EmailList.Add(onemail); } } } return(_EmailList); }
public string SaveEssencialDecission(EmailInforType.EssencialDecissionType _SaveData) { MySqlCommand oSqlCommand = new MySqlCommand(); string sqlQuery = "Insert Into ecoessencialdecission (" + "SysID," + "Department," + "FirstPerson," + "FirstEmail," + "SecondPeson," + "SeconfEmail," + "Status)" + " Values (" + "@SysID," + "@Department," + "@FirstPerson," + "@FirstEmail," + "@SecondPeson," + "@SeconfEmail," + "@Status)"; try { oSqlCommand.Parameters.AddWithValue("@SysID", _SaveData.SysID); oSqlCommand.Parameters.AddWithValue("@Department", _SaveData.Department); oSqlCommand.Parameters.AddWithValue("@FirstPerson", _SaveData.FirstPerson); oSqlCommand.Parameters.AddWithValue("@FirstEmail", _SaveData.FirstEmail); oSqlCommand.Parameters.AddWithValue("@SeconfEmail", _SaveData.SecondEmail); oSqlCommand.Parameters.AddWithValue("@SecondPeson", _SaveData.SecondPeson); oSqlCommand.Parameters.AddWithValue("@Status", _SaveData.Status); string respond = Mycommon.ExicuteAnyCommand(sqlQuery, oSqlCommand, null, "SAve ECO Email"); return(respond); } catch (Exception ex) { return(ex.Message); } }
public string GetExistEssencialDecission(int SysID,out EmailInforType.EssencialDecissionType _ExistData) { _ExistData=new EmailInforType.EssencialDecissionType(); MySqlCommand oSqlCommand=new MySqlCommand(); string sqlQuery ="Select " + "SysID," + "Department," + "FirstPerson," + "FirstEmail," + "SecondPeson," + "SeconfEmail," + "Status" + " from ecoessencialdecission" + " Where 1=1 and status=1 " + " and SysID=" + SysID ; DataRow r=Mycommon.GetDataRow(sqlQuery,"get Email Data"); if (r !=null) { try { bool resp=false; int inSysID=0; resp = int.TryParse(r["SysID"].ToString(), out inSysID); _ExistData.SysID = inSysID; _ExistData.Department = r["Department"].ToString(); _ExistData.FirstPerson = r["FirstPerson"].ToString(); _ExistData.FirstEmail = r["FirstEmail"].ToString(); _ExistData.SecondPeson = r["SecondPeson"].ToString(); _ExistData.SecondEmail = r["SeconfEmail"].ToString(); int inStatus=0; resp = int.TryParse(r["Status"].ToString(), out inStatus); _ExistData.Status = inStatus; return "True"; } catch (Exception ex) { return ex.Message; } } else return "data not found "; }
public List<EmailInforType.EssencialDecissionType> GetEmailDecissionList() { List<EmailInforType.EssencialDecissionType> _EmailList = new List<EmailInforType.EssencialDecissionType>(); string sql1 = "Select SysID from ecoessencialdecission where status=1"; DataTable tb = new DataTable(); tb = Mycommon.GetDataTable(sql1, "Get Email List"); if (tb != null) { foreach (DataRow r in tb.Rows) { EmailInforType.EssencialDecissionType onemail = new EmailInforType.EssencialDecissionType(); string respond = GetExistEssencialDecission(int.Parse(r["Sysid"].ToString()), out onemail); if (respond == "True") _EmailList.Add(onemail); } } return _EmailList; }