public static CustSearchMl CustomerViewProfileEncriptedText(CustSearchMl MobjViewprofile)
{
if (MobjViewprofile.TypeofInsert == "E")
{
MobjViewprofile.EncriptedText = Commonclass.ReturnEncryptLink("Accept", (!string.IsNullOrEmpty(MobjViewprofile.FromProfileID) ? MobjViewprofile.FromProfileID : null), (!string.IsNullOrEmpty(MobjViewprofile.ToProfileID) ? MobjViewprofile.ToProfileID : null));
MobjViewprofile.EncryptedRejectFlagText = Commonclass.ReturnEncryptLink("Reject", !string.IsNullOrEmpty(MobjViewprofile.FromProfileID) ? MobjViewprofile.FromProfileID : null, !string.IsNullOrEmpty(MobjViewprofile.ToProfileID) ? MobjViewprofile.ToProfileID : null);
MobjViewprofile.EncriptedTextrvr = Commonclass.ReturnEncryptLink("Accept", (!string.IsNullOrEmpty(MobjViewprofile.ToProfileID) ? MobjViewprofile.ToProfileID : null), (!string.IsNullOrEmpty(MobjViewprofile.FromProfileID) ? MobjViewprofile.FromProfileID : null));
MobjViewprofile.EncryptedRejectFlagTextrvr = Commonclass.ReturnEncryptLink("Reject", !string.IsNullOrEmpty(MobjViewprofile.ToProfileID) ? MobjViewprofile.ToProfileID : null, !string.IsNullOrEmpty(MobjViewprofile.FromProfileID) ? MobjViewprofile.FromProfileID : null);
}
return(MobjViewprofile);
}
public class ImpCustSearchService : ICustSearchService { public int CustomerServiceDal(CustSearchMl MobjViewprofile)
{
if (MobjViewprofile.TypeofInsert == "E")
{
MobjViewprofile = Commonclass.CustomerViewProfileEncriptedText(MobjViewprofile);
}
return(new CustomerServiceDAL().getCustomerServiceDal(MobjViewprofile, "[dbo].[usp_insert_customerDashboard]"));
}
public int SaveViewedBookmark_Customer([FromBody] CustSearchMl Mobj)
{
return(this.IEmployeeReport.SaveViewedBookmark_Customer(Mobj));
}
public int getCustomerServiceDal(CustSearchMl MobjViewprofile, string spName)
{
SqlParameter[] parm = new SqlParameter[14];
int istatus = 0;
List <Smtpemailsending> li = new List <Smtpemailsending>();
SqlDataReader reader;
SqlConnection connection = new SqlConnection();
connection = SQLHelper.GetSQLConnection();
connection.Open();
try
{
parm[0] = new SqlParameter("@fromcustid", SqlDbType.Int);
parm[0].Value = MobjViewprofile.IFromCustID;
parm[1] = new SqlParameter("@toCustID", SqlDbType.Int);
parm[1].Value = MobjViewprofile.IToCustID;
parm[2] = new SqlParameter("@TypeofInsert", SqlDbType.VarChar);
parm[2].Value = MobjViewprofile.TypeofInsert;
parm[3] = new SqlParameter("@i_Acceptlink", SqlDbType.VarChar);
parm[3].Value = MobjViewprofile.EncriptedText;
parm[4] = new SqlParameter("@i_Rejectlink", SqlDbType.VarChar);
parm[4].Value = MobjViewprofile.EncryptedRejectFlagText;
parm[5] = new SqlParameter("@i_RVRAcceptlink", SqlDbType.VarChar);
parm[5].Value = MobjViewprofile.EncriptedTextrvr;
parm[6] = new SqlParameter("@i_RVRRejectlink", SqlDbType.VarChar);
parm[6].Value = MobjViewprofile.EncryptedRejectFlagTextrvr;
parm[7] = new SqlParameter("@vc_Message", SqlDbType.VarChar);
parm[7].Value = MobjViewprofile.StrHtmlText;
parm[8] = new SqlParameter("@i_MessagelinkID", SqlDbType.BigInt);
parm[8].Value = MobjViewprofile.MessageLinkId;
parm[9] = new SqlParameter("@i_Cust_MessageHistory_Id", SqlDbType.BigInt);
parm[9].Value = MobjViewprofile.MessageHistoryId;
parm[10] = new SqlParameter("@i_LogId", SqlDbType.BigInt);
parm[10].Value = MobjViewprofile.Logid;
parm[11] = new SqlParameter("@i_status", SqlDbType.Int);
parm[11].Direction = ParameterDirection.Output;
DataSet dsMessages = new DataSet();
reader = SQLHelper.ExecuteReader(connection, CommandType.StoredProcedure, spName, parm);
if (reader.HasRows)
{
while (reader.Read())
{
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;
istatus = smtp.Statusint = (reader["Status"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Status")) : 0;
}
li.Add(smtp);
}
}
reader.Close();
if (MobjViewprofile.TypeofInsert == "I" || MobjViewprofile.TypeofInsert == "RP" || MobjViewprofile.TypeofInsert == "TH")
{
if (string.Compare(parm[11].Value.ToString(), System.DBNull.Value.ToString()) == 0)
{
istatus = 0;
}
else
{
istatus = Convert.ToInt32(parm[11].Value);
}
}
if (MobjViewprofile.TypeofInsert == "M" || MobjViewprofile.TypeofInsert == "B")
{
Commonclass.SendMailSmtpMethod(li, "info");
}
else
{
Commonclass.SendMailSmtpMethod(li, "exp");
}
}
catch (Exception EX)
{
Commonclass.ApplicationErrorLog(spName, Convert.ToString(EX.Message), MobjViewprofile.IFromCustID, null, null);
}
finally
{
connection.Close();
//SqlConnection.ClearPool(connection);
//SqlConnection.ClearAllPools();
}
return(istatus);
}
public int CustomerServiceBal([FromBody] CustSearchMl MobjViewprofile)
{
return(this.ICustSearchService.CustomerServiceDal(MobjViewprofile));
}
public int SaveViewedBookmark_Customer(CustSearchMl Mobj)
{
return(new EmployeeReportPageDAL().SaveViewedBookmark_Customer(Mobj, "[dbo].[usp_Cust_ProfileMarked_Insert]"));
}
