public DataSet ExpressInterest_sendmultimails(ExpressInterestInsert ExpML, string spName)
{
List <Smtpemailsending> li = new List <Smtpemailsending>();
SqlConnection connection = new SqlConnection();
DataSet dtFromTo = new DataSet();
connection = SQLHelper.GetSQLConnection();
connection.Open();
try
{
SqlParameter[] parm = new SqlParameter[5];
parm[0] = new SqlParameter("@cust_Id", SqlDbType.Int);
parm[0].Value = ExpML.FromCustID;
parm[1] = new SqlParameter("@empid", SqlDbType.BigInt);
parm[1].Value = ExpML.EmpID;
parm[2] = new SqlParameter("@TblDetails", SqlDbType.Structured);
parm[2].Value = ExpML.dtExpInt;
parm[3] = new SqlParameter("@emailaddress", SqlDbType.VarChar);
parm[3].Value = ExpML.emailaddress;
parm[4] = new SqlParameter("@Status", SqlDbType.Int);
parm[4].Direction = ParameterDirection.Output;
// reader = SQLHelper.ExecuteReader(connection, CommandType.StoredProcedure, spName, parm);
dtFromTo = SQLHelper.ExecuteDataset(connection, CommandType.StoredProcedure, spName, parm);
Commonclass.ExpressInterestSMS(ExpML.dtExpInt, " ");
}
catch (Exception ex)
{
throw ex;
}
finally
{
connection.Close();
}
return(dtFromTo);
}
public DataSet ExpressInterest_sendmultimails(ExpressInterestInsert ExpML)
{
return(new ExpressInterestDAL().ExpressInterest_sendmultimails(ExpML, "[dbo].[usp_Emp_ExpressInterst_Insert_New]"));
}
// public Tuple<List<Smtpemailsending>, int?> ExpressInterest(ExpressInterestInsert ExpML) { return new ExpressInterestDAL().ExpressInterest(ExpML, "[dbo].[usp_ExpressInterst_Insert_New]"); }
public Tuple <List <Smtpemailsending>, int?> ExpressInterest(ExpressInterestInsert ExpML)
{
return(new ExpressInterestDAL().ExpressInterest(ExpML, "[dbo].[usp_Emp_ExpressInterst_SendMaile]"));
}
public Tuple <List <Smtpemailsending>, int?> ExpressInterest([FromBody] JObject CgetDetails)
{
List <TExpressInterest> lstExpress = new List <TExpressInterest>();
object obj = (object)CgetDetails["GetDetails"];
var objs = JsonConvert.DeserializeObject <List <TExpressInterest> >(obj.ToString());
DataSet dsResult = new DataSet();
DataTable dtExpress = new DataTable();
DataTable dtResultSet = new DataTable();
string strfromprofileID = string.Empty;
string strtoPRofileID = string.Empty;
bool IsRvrSend = false;
ExpressInterestInsert EXI = CgetDetails["customerpersonaldetails"].ToObject <ExpressInterestInsert>();
lstExpress = objs;
dtExpress = Commonclass.returnListDatatable(PersonaldetailsUDTables.dtExpressInterestTable(), lstExpress);
if (dtExpress != null && dtExpress.Rows.Count > 0)
{
strfromprofileID = dtExpress.Rows[0]["FromProfileID"].ToString();
strtoPRofileID = dtExpress.Rows[0]["ToProfileID"].ToString();
IsRvrSend = Convert.ToBoolean(dtExpress.Rows[0]["IsRvrSend"].ToString());
foreach (DataRow dr in dtExpress.Rows)
{
string FromProfileID = dr["FromProfileID"].ToString();
string ToProfileID = dr["ToProfileID"].ToString();
dr["Acceptlink"] = Commonclass.getEncryptedExpressIntrestString("FromProfileID=" + FromProfileID + "&" + "ToProfileID=" + ToProfileID + "&" + "Flag=" + 1);
dr["Rejectlink"] = Commonclass.getEncryptedExpressIntrestString("FromProfileID=" + FromProfileID + "&" + "ToProfileID=" + ToProfileID + "&" + "Flag=" + 0);
dr["RvrAcceptlink"] = Commonclass.getEncryptedExpressIntrestString("FromProfileID=" + ToProfileID + "&" + "ToProfileID=" + FromProfileID + "&" + "Flag=" + 1);
dr["RvrRejectlink"] = Commonclass.getEncryptedExpressIntrestString("FromProfileID=" + ToProfileID + "&" + "ToProfileID=" + FromProfileID + "&" + "Flag=" + 0);
dr["Sendsms"] = (!string.IsNullOrEmpty(dr["Sendsms"].ToString()) && dr["Sendsms"].ToString() == "True") ? true : false;
dr["IsRvrSend"] = (!string.IsNullOrEmpty(dr["IsRvrSend"].ToString()) && dr["IsRvrSend"].ToString() == "True") ? true : false;
}
}
EXI.dtExpInt = dtExpress;
dsResult = this.IExpressInterest.ExpressInterest_sendmultimails(EXI);
#region
//if (IsRvrSend == true)
//{
// DataTable tblFilteredTo = dsResult.Tables[0].AsEnumerable().Where(row => row.Field<String>("FromProfileID") == strfromprofileID).CopyToDataTable();
// EXI.dtExpInt = tblFilteredTo;
// if (EXI.dtExpInt != null && EXI.dtExpInt.Rows.Count > 0)
// {
// foreach (DataRow dr in EXI.dtExpInt.Rows)
// {
// string FromProfileID = dr["FromProfileID"].ToString();
// string ToProfileID = dr["ToProfileID"].ToString();
// if (strfromprofileID == FromProfileID)
// {
// dr["Acceptlink"] = Commonclass.getEncryptedExpressIntrestString("FromProfileID=" + FromProfileID + "&" + "ToProfileID=" + ToProfileID + "&" + "Flag=" + 1);
// dr["Rejectlink"] = Commonclass.getEncryptedExpressIntrestString("FromProfileID=" + FromProfileID + "&" + "ToProfileID=" + ToProfileID + "&" + "Flag=" + 0);
// dr["RvrAcceptlink"] = Commonclass.getEncryptedExpressIntrestString("FromProfileID=" + ToProfileID + "&" + "ToProfileID=" + FromProfileID + "&" + "Flag=" + 1);
// dr["RvrRejectlink"] = Commonclass.getEncryptedExpressIntrestString("FromProfileID=" + ToProfileID + "&" + "ToProfileID=" + FromProfileID + "&" + "Flag=" + 0);
// dr["Sendsms"] = (!string.IsNullOrEmpty(dr["Sendsms"].ToString()) && dr["Sendsms"].ToString() == "True") ? true : false;
// dr["IsRvrSend"] = (!string.IsNullOrEmpty(dr["IsRvrSend"].ToString()) && dr["IsRvrSend"].ToString() == "True") ? true : false;
// }
// }
// this.IExpressInterest.ExpressInterest(EXI);
// }
//}
//EXI.dtExpInt.Rows.Clear();
//DataTable tblFiltered = dsResult.Tables[0].AsEnumerable().Where(row => row.Field<String>("FromProfileID") == strtoPRofileID).CopyToDataTable();
#endregion
EXI.dtExpInt = dsResult.Tables[0];
if (EXI.dtExpInt != null && EXI.dtExpInt.Rows.Count > 0)
{
foreach (DataRow dr in EXI.dtExpInt.Rows)
{
string FromProfileID = dr["FromProfileID"].ToString();
string ToProfileID = dr["ToProfileID"].ToString();
//if (strfromprofileID == ToProfileID)
//{
dr["Acceptlink"] = Commonclass.getEncryptedExpressIntrestString("FromProfileID=" + FromProfileID + "&" + "ToProfileID=" + ToProfileID + "&" + "Flag=" + 1);
dr["Rejectlink"] = Commonclass.getEncryptedExpressIntrestString("FromProfileID=" + FromProfileID + "&" + "ToProfileID=" + ToProfileID + "&" + "Flag=" + 0);
dr["RvrAcceptlink"] = Commonclass.getEncryptedExpressIntrestString("FromProfileID=" + ToProfileID + "&" + "ToProfileID=" + FromProfileID + "&" + "Flag=" + 1);
dr["RvrRejectlink"] = Commonclass.getEncryptedExpressIntrestString("FromProfileID=" + ToProfileID + "&" + "ToProfileID=" + FromProfileID + "&" + "Flag=" + 0);
dr["Sendsms"] = (!string.IsNullOrEmpty(dr["Sendsms"].ToString()) && dr["Sendsms"].ToString() == "True") ? true : false;
dr["IsRvrSend"] = (!string.IsNullOrEmpty(dr["IsRvrSend"].ToString()) && dr["IsRvrSend"].ToString() == "True") ? true : false;
//}
}
}
return(this.IExpressInterest.ExpressInterest(EXI));
}
public Tuple <List <Smtpemailsending>, int?> ExpressInterest(ExpressInterestInsert ExpML, string spName)
{
int?status = null;
SqlDataReader reader;
List <Smtpemailsending> li = new List <Smtpemailsending>();
SqlConnection connection = new SqlConnection();
connection = SQLHelper.GetSQLConnection();
connection.Open();
try
{
SqlParameter[] parm = new SqlParameter[5];
parm[0] = new SqlParameter("@cust_Id", SqlDbType.Int);
parm[0].Value = ExpML.FromCustID;
parm[1] = new SqlParameter("@empid", SqlDbType.BigInt);
parm[1].Value = ExpML.EmpID;
parm[2] = new SqlParameter("@TblDetails", SqlDbType.Structured);
parm[2].Value = ExpML.dtExpInt;
parm[3] = new SqlParameter("@emailaddress", SqlDbType.VarChar);
parm[3].Value = ExpML.emailaddress;
parm[4] = new SqlParameter("@Status", SqlDbType.Int);
parm[4].Direction = ParameterDirection.Output;
reader = SQLHelper.ExecuteReader(connection, CommandType.StoredProcedure, spName, parm);
if (reader.HasRows)
{
while (reader.Read())
{
li.Clear();
Smtpemailsending smtp = new Smtpemailsending();
{
smtp.profile_name = (reader["profile_name"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("profile_name")) : string.Empty;
smtp.recipients = (reader["recipients"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("recipients")) : string.Empty;
smtp.body = (reader["body"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("body")) : string.Empty;
smtp.subject = (reader["subject"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("subject")) : string.Empty;
smtp.body_format = (reader["body_format"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("body_format")) : string.Empty;
smtp.Status = (reader["Status"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Status")) : status;
}
li.Add(smtp);
Commonclass.SendMailSmtpMethod(li, "exp");
}
}
Commonclass.ExpressInterestSMS(ExpML.dtExpInt, " ");
reader.Close();
}
catch (Exception ex)
{
throw ex;
}
finally
{
connection.Close();
}
return(new Tuple <List <Smtpemailsending>, int?>(li, status));
}
