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;
}
