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