public List <Paymentselect> GetPaymentDetails(long?CustID, string spName)
{
SqlParameter[] parm = new SqlParameter[3];
SqlDataReader reader = null;
List <Paymentselect> arrayList = new List <Paymentselect>();
int? intnull = null;
double? floatnull = null;
SqlConnection connection = new SqlConnection();
connection = SQLHelper.GetSQLConnection();
connection.Open();
try
{
parm[0] = new SqlParameter("@i_FromCustID", SqlDbType.BigInt);
parm[0].Value = CustID;
reader = SQLHelper.ExecuteReader(connection, CommandType.StoredProcedure, spName, parm);
if (reader.HasRows)
{
while (reader.Read())
{
Paymentselect payment = new Paymentselect();
{
payment.MembershipName = reader["MembershipName"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("MembershipName")) : null;
payment.Emp_Membership_ID = reader["Emp_Membership_ID"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Emp_Membership_ID")) : intnull;
payment.MemberShipDuration = reader["MemberShipDuration"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("MemberShipDuration")) : intnull;
payment.Cust_MemberShip_Discount_ID = reader["Cust_MemberShip_Discount_ID"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Cust_MemberShip_Discount_ID")) : intnull;
payment.DiscountAmount = reader["DiscountAmount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("DiscountAmount")) : intnull;
payment.AllottedServicePoints = reader["AllottedServicePoints"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("AllottedServicePoints")) : intnull;
payment.MembershipAmount = reader["MembershipAmount"] != DBNull.Value ? reader.GetDouble(reader.GetOrdinal("MembershipAmount")) : floatnull;
payment.onlineaccess = reader["onlineaccess"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("onlineaccess")) : null;
payment.offlineaccess = reader["offlineaccess"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("offlineaccess")) : null;
payment.Ppluspath = reader["Ppluspath"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("Ppluspath")) : null;
payment.Ppath = reader["Ppath"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("Ppath")) : null;
}
arrayList.Add(payment);
}
}
reader.NextResult();
if (reader.HasRows)
{
while (reader.Read())
{
Paymentselect payment = new Paymentselect();
{
payment.MembershipName = reader["MembershipName"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("MembershipName")) : null;
payment.Emp_Membership_ID = reader["Emp_Membership_ID"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Emp_Membership_ID")) : intnull;
payment.MemberShipDuration = reader["MemberShipDuration"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("MemberShipDuration")) : intnull;
payment.Cust_MemberShip_Discount_ID = reader["Cust_MemberShip_Discount_ID"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Cust_MemberShip_Discount_ID")) : intnull;
payment.DiscountAmount = reader["DiscountAmount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("DiscountAmount")) : intnull;
payment.AllottedServicePoints = reader["AllottedServicePoints"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("AllottedServicePoints")) : intnull;
payment.AccessFeature = reader["AccessFeature"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("AccessFeature")) : intnull;
payment.MembershipAmount = reader["MembershipAmount"] != DBNull.Value ? reader.GetDouble(reader.GetOrdinal("MembershipAmount")) : floatnull;
}
arrayList.Add(payment);
}
}
reader.Close();
}
catch (Exception EX)
{
Commonclass.ApplicationErrorLog(spName, Convert.ToString(EX.Message), CustID, null, null);
}
finally
{
connection.Close();
}
return(arrayList);
}
public Tuple <EmpDetailsMl, List <MenuItem>, List <ScrollText>, List <StarRating>, int> ValidateLoginNew(string LoginName, string Password, string sMAC, string spName)
{
int intstatus = 0;
SqlParameter[] param = new SqlParameter[5];
SqlConnection connection = new SqlConnection();
connection = SQLHelper.GetSQLConnection();
connection.Open();
EmpDetailsMl empDetails = new EmpDetailsMl();
List <MenuItem> lstPagePermissions = new List <MenuItem>();
List <ScrollText> lscroll = new List <ScrollText>();
List <StarRating> lstarrating = new List <StarRating>();
try
{
param[0] = new SqlParameter("@LoginName", System.Data.SqlDbType.VarChar);
param[0].Value = LoginName;
param[1] = new SqlParameter("@Password", System.Data.SqlDbType.VarChar);
param[1].Value = Password;
param[2] = new SqlParameter("@Mac", System.Data.SqlDbType.VarChar);
param[2].Value = sMAC;
param[3] = new SqlParameter("@ErrorMsg", System.Data.SqlDbType.VarChar, 10000);
param[3].Direction = ParameterDirection.Output;
param[4] = new SqlParameter("@Status", System.Data.SqlDbType.Int);
param[4].Direction = ParameterDirection.Output;
DataSet dsLogin = SQLHelper.ExecuteDataset(connection, CommandType.StoredProcedure, spName, param);
if (string.Compare(System.DBNull.Value.ToString(), param[4].Value.ToString()) == 0)
{
intstatus = 0;
}
else
{
intstatus = Convert.ToInt32(param[4].Value);
}
if (string.Compare(System.DBNull.Value.ToString(), param[4].Value.ToString()) == 0)
{
intstatus = 0;
}
else
{
if (param[4].Value.ToString() == "1")
{
int? intNull = null;
DateTime datetimeNull = Convert.ToDateTime(null);
DataTable dtLogin = dsLogin.Tables[0];
empDetails.EmpID = Int64.Parse(dtLogin.Rows[0]["EmpID"].ToString());
empDetails.FirstName = dtLogin.Rows[0]["FirstName"].ToString();
empDetails.LastName = dtLogin.Rows[0]["LastName"].ToString();
empDetails.WorkingStartTIme = DateTime.Parse(dtLogin.Rows[0]["WorkingStartTime"].ToString());
empDetails.WorkingEndTIme = DateTime.Parse(dtLogin.Rows[0]["WorkingEndTIme"].ToString());
empDetails.DesignationID = int.Parse(dtLogin.Rows[0]["DesignationID"].ToString());
empDetails.ReportingMngrID = (dtLogin.Rows[0]["ReportingMngrID"] != DBNull.Value) ? int.Parse(dtLogin.Rows[0]["ReportingMngrID"].ToString()) : 0;
empDetails.BranchID = int.Parse(dtLogin.Rows[0]["BranchID"].ToString());
empDetails.LastLoginDate = !string.IsNullOrEmpty(dtLogin.Rows[0]["LastLoginDate"].ToString()) ? DateTime.Parse(dtLogin.Rows[0]["LastLoginDate"].ToString()) : datetimeNull;
empDetails.Email = dtLogin.Rows[0]["Email"].ToString();
empDetails.isAdmin = !string.IsNullOrEmpty(dtLogin.Rows[0]["isAdmin"].ToString()) ? Convert.ToInt32(dtLogin.Rows[0]["isAdmin"].ToString()) : -1;
empDetails.RegionID = !string.IsNullOrEmpty(dtLogin.Rows[0]["Region"].ToString()) ? Convert.ToInt32(dtLogin.Rows[0]["Region"].ToString()) : intNull;
empDetails.isManagement = !string.IsNullOrEmpty(dtLogin.Rows[0]["isManagement"].ToString()) ? Convert.ToBoolean(dtLogin.Rows[0]["isManagement"].ToString()) : false;
empDetails.EmpPhotoPath = !string.IsNullOrEmpty(dtLogin.Rows[0]["EmpPhotoPath"].ToString()) ? dtLogin.Rows[0]["EmpPhotoPath"].ToString() : null;
empDetails.Dashboard_Status = !string.IsNullOrEmpty(dtLogin.Rows[0]["Dashboard_Status"].ToString()) ? Convert.ToInt32(dtLogin.Rows[0]["Dashboard_Status"]) : intNull;
empDetails.UserID = (dtLogin.Rows[0]["UserID"].ToString());
}
else
{
// intstatus = 0;
}
}
}
catch (Exception EX)
{
Commonclass.ApplicationErrorLog(spName, Convert.ToString(EX.Message), null, null, null);
}
finally
{
connection.Close();
}
return(new Tuple <EmpDetailsMl, List <MenuItem>, List <ScrollText>, List <StarRating>, int>(empDetails, lstPagePermissions, lscroll, lstarrating, intstatus));
}
public List <userLoginML> DGetLogininformationdetails(CustLoginMl Mobj)
{
int status = 0;
List <userLoginML> userLogin = null;
SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["KakConnection"].ToString());
connection.Open();
try
{
SqlCommand command = new SqlCommand("Usp_CheckCustLogin", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@Username", Mobj.Username);
command.Parameters.AddWithValue("@Password", Commonclass.Encrypt(Mobj.Password));
SqlParameter outputParamStatus = command.Parameters.Add("@Status", SqlDbType.Int);
outputParamStatus.Direction = ParameterDirection.Output;
SqlDataReader reader;
reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
userLogin = new List <userLoginML>
{
new userLoginML
{
CustID = (reader["CustID"]) != DBNull.Value ? reader.GetInt64(reader.GetOrdinal("CustID")) : 0,
FirstName = (reader["FirstName"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("FirstName")) : null,
LastName = (reader["LastName"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("LastName")) : null,
ReligionName = (reader["ReligionName"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("ReligionName")) : null,
CasteName = (reader["CasteName"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("CasteName")) : null,
CasteID = (reader["CasteID"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("CasteID")) : 0,
MotherTongueName = (reader["MotherTongueName"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("MotherTongueName")) : null,
GenderID = (reader["GenderID"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("GenderID")) : 0,
Email = (reader["Email"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("Email")) : null,
MotherTongueID = (reader["MotherTongueID"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("MotherTongueID")) : 0,
ReligionID = (reader["ReligionID"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("ReligionID")) : 0,
ProfileID = (reader["ProfileID"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("ProfileID")) : null,
VerificationCode = (reader["VerificationCode"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("VerificationCode")) : null,
FamilyID = (reader["FamilyID"]) != DBNull.Value ? reader.GetInt64(reader.GetOrdinal("FamilyID")) : 0,
PaidStatus = (reader["PaidStatus"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("PaidStatus")) : 0,
PartnerCastedata = (reader["PartnerCastedata"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("PartnerCastedata")) : null,
PhotoStatus = (reader["PhotoStatus"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("PhotoStatus")) : 0,
PhotoCount = (reader["PhotoCount"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("PhotoCount")) : 0,
ViewProfileFlag = (reader["ViewProfileFlag"]) != DBNull.Value ? reader.GetBoolean(reader.GetOrdinal("ViewProfileFlag")) : false,
ResigNophotoFlgPaid = (reader["ResigNophotoFlgPaid"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("ResigNophotoFlgPaid")) : 0,
SuccessStoryFlag = (reader["SuccessStoryFlag"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("SuccessStoryFlag")) : 0,
Emailverified = (reader["Emailverified"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Emailverified")) : 0,
strProfileID = (reader["ProfileID"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("ProfileID")) : null,
Flag = (reader["Flag"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Flag")) : 0,
cust_emailid = (reader["cust_emailid"]) != DBNull.Value ? reader.GetInt64(reader.GetOrdinal("cust_emailid")) : 0,
email = (reader["email"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("email")) : null,
isemailverified = (reader["isemailverified"]) != DBNull.Value ? reader.GetBoolean(reader.GetOrdinal("isemailverified")) : false,
cust_contant_id = (reader["cust_contant_id"]) != DBNull.Value ? reader.GetInt64(reader.GetOrdinal("cust_contant_id")) : 0,
number = (reader["number"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("number")) : null,
isnumberverifed = (reader["isnumberverifed"]) != DBNull.Value ? reader.GetBoolean(reader.GetOrdinal("isnumberverifed")) : false,
MObileverficationcode = (reader["MObileverficationcode"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("MObileverficationcode")) : null,
ProfilePic = (reader["ProfilePic"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("ProfilePic")) : null
},
};
}
}
reader.Close();
status = (int)command.Parameters["@Status"].Value;
}
catch (Exception EX)
{
Commonclass.ApplicationErrorLog("Usp_CheckCustLogin", Convert.ToString(EX.Message), null, null, null);
}
finally
{
connection.Close();
}
return(userLogin);
}
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));
}
public static bool S3upload(string filePath, string keyName)
{
//filePath = "D://KaakateeyaMainProject//Kaakateeya//Development_Kaakateeya//kaakateeyaWeb//access//Images//ProfilePics//KMPL_71668_Images//img2.jpg";
string strpath = keyName.Replace("/", "//");
//filePath = "C://inetpub//wwwroot//access//" + strpath;
//filePath = "http://emp.kaakateeya.com//" + strpath;
//filePath = "http://183.82.0.58:9030//" + strpath;
//filePath = "D://EmployeeAngularSite//Employee//" + strpath;
//filePath = "C://EmployeeAngularProject//Employee//" + strpath;
filePath = "C://EmployeeAngularProject_New//EmployeeProject//" + strpath;
try
{
TransferUtility fileTransferUtility = new
TransferUtility(new AmazonS3Client(Amazon.RegionEndpoint.APSouth1));
//TransferUtility utility = new TransferUtility();
//utility.UploadDirectory(directoryPath, bucketName);
// 1. Upload a file, file name is used as the object key name.
//fileTransferUtility.Upload(filePath, bucketName);
//Console.WriteLine("Upload 1 completed");
//// 2. Specify object key name explicitly.
//fileTransferUtility.Upload(filePath,
// bucketName, keyName);
//Console.WriteLine("Upload 2 completed");
//// 3. Upload data from a type of System.IO.Stream.
//using (FileStream fileToUpload =
// new FileStream(filePath, FileMode.Open, FileAccess.Read))
//{
// fileTransferUtility.Upload(fileToUpload,
// bucketName, keyName);
//}
//Console.WriteLine("Upload 3 completed");
// 4.Specify advanced settings/options.
TransferUtilityUploadRequest fileTransferUtilityRequest = new TransferUtilityUploadRequest
{
BucketName = "kaakateeyaprod",
FilePath = filePath,
StorageClass = S3StorageClass.ReducedRedundancy,
PartSize = 6291456, // 6 MB.
Key = keyName,
CannedACL = S3CannedACL.PublicRead
};
fileTransferUtilityRequest.Metadata.Add("param1", "Value1");
fileTransferUtilityRequest.Metadata.Add("param2", "Value2");
fileTransferUtility.Upload(fileTransferUtilityRequest);
return(true);
}
catch (AmazonS3Exception s3Exception)
{
Commonclass.ApplicationErrorLog("s3 Horo", Convert.ToString(s3Exception.Message), null, null, null);
return(false);
}
finally
{
// SqlConnection.ClearAllPools();
}
}
public int InsertExpressViewTicket(long?FromCustID, long?ToCustID, string EncriptedText, string strtypeOfReport, string spName)
{
int? Istatus = null;
int? inull = null;
SqlDataReader reader = null;
int status = 0;
List <Smtpemailsending> li = new List <Smtpemailsending>();
SqlConnection connection = new SqlConnection();
connection = SQLHelper.GetSQLConnection();
connection.Open();
SqlParameter[] parm = new SqlParameter[6];
try
{
parm[0] = new SqlParameter("@fromcust_id", SqlDbType.BigInt);
parm[0].Value = FromCustID;
parm[1] = new SqlParameter("@tocust_id", SqlDbType.BigInt);
parm[1].Value = ToCustID;
parm[2] = new SqlParameter("@EncriptedTextAccept", SqlDbType.VarChar);
parm[2].Value = EncriptedText;
parm[3] = new SqlParameter("@Typeofaction", SqlDbType.VarChar);
parm[3].Value = strtypeOfReport;
parm[4] = new SqlParameter("@Status", SqlDbType.Int);
parm[4].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.Status = (reader["Status"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Status")) : inull;
}
li.Add(smtp);
}
status = Istatus != null?Convert.ToInt32(Istatus) : 0;
Commonclass.SendMailSmtpMethod(li, "info");
}
else
{
if (string.Compare(System.DBNull.Value.ToString(), parm[4].Value.ToString()) == 0)
{
status = 0;
}
else
{
status = Convert.ToInt32(parm[4].Value);
}
}
reader.Close();
}
catch (Exception EX)
{
Commonclass.ApplicationErrorLog(spName, Convert.ToString(EX.Message), FromCustID, null, null);
}
finally
{
connection.Close();
//SqlConnection.ClearPool(connection);
//SqlConnection.ClearAllPools();
}
return(status);
}
public List <CommunicationHistry> GetCustometMessagesCount(CommunicationHistoryReq Mobj, string spName)
{
SqlParameter[] parm = new SqlParameter[7];
SqlDataReader reader;
List <CommunicationHistry> arrayList = new List <CommunicationHistry>();
Int64? intNUll = null;
int? intnull = null;
bool? iboolean = null;
SqlConnection connection = new SqlConnection();
connection = SQLHelper.GetSQLConnection();
connection.Open();
try
{
parm[0] = new SqlParameter("@CustID", SqlDbType.BigInt);
parm[0].Value = Mobj.CustID;
parm[1] = new SqlParameter("@i_MessageStatusId", SqlDbType.Int);
parm[1].Value = Mobj.MessageStatusID;
parm[2] = new SqlParameter("@i_MessageLinkId", SqlDbType.BigInt);
parm[2].Value = Mobj.MessageLinkId;
parm[3] = new SqlParameter("@i_PageSize", SqlDbType.Int);
parm[3].Value = Mobj.i_PageSize;
parm[4] = new SqlParameter("@i_PageNumber", SqlDbType.Int);
parm[4].Value = Mobj.i_PageNumber;
parm[5] = new SqlParameter("@i_StartIndex", SqlDbType.Int);
parm[5].Value = Mobj.i_StartIndex;
parm[6] = new SqlParameter("@i_EndIndex", SqlDbType.Int);
parm[6].Value = Mobj.i_EndIndex;
reader = SQLHelper.ExecuteReader(connection, CommandType.StoredProcedure, spName, parm);
if (reader.HasRows)
{
while (reader.Read())
{
CommunicationHistry communicationHistory = new CommunicationHistry();
{
communicationHistory.Sender = reader["Sender"] != DBNull.Value ? reader.GetInt64(reader.GetOrdinal("Sender")) : intNUll;
communicationHistory.Receiver = reader["Receiver"] != DBNull.Value ? reader.GetInt64(reader.GetOrdinal("Receiver")) : intNUll;
communicationHistory.SenderName = reader["SenderName"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("SenderName")) : null;
communicationHistory.ReceiverName = reader["ReceiverName"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("ReceiverName")) : null;
communicationHistory.Body = reader["Body"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("Body")) : null;
communicationHistory.RequestDate = reader["RequestDate"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("RequestDate")) : null;
communicationHistory.IsReviewd = reader["IsReviewd"] != DBNull.Value ? reader.GetBoolean(reader.GetOrdinal("IsReviewd")) : iboolean;
communicationHistory.Cust_MessageLink_Id = reader["Cust_MessageLink_Id"] != DBNull.Value ? reader.GetInt64(reader.GetOrdinal("Cust_MessageLink_Id")) : intNUll;
communicationHistory.MessageStatusID = reader["MessageStatusID"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("MessageStatusID")) : intnull;
communicationHistory.loginCustid = reader["loginCustid"] != DBNull.Value ? reader.GetInt64(reader.GetOrdinal("loginCustid")) : intNUll;
}
arrayList.Add(communicationHistory);
}
}
}
catch (Exception EX)
{
Commonclass.ApplicationErrorLog(spName, Convert.ToString(EX.Message), Mobj.CustID, null, null);
}
finally
{
connection.Close();
//SqlConnection.ClearPool(connection);
//SqlConnection.ClearAllPools();
}
return(arrayList);
}
public List <TicketHistoryinfoResponse> GetTicketinformationDal(long?Ticketid, char Type, string spName)
{
List <TicketHistoryinfoResponse> details = new List <TicketHistoryinfoResponse>();
SqlDataReader reader;
DataSet ds = new DataSet();
DataTable dt = new DataTable();
string Snull = "--";
Int64? Lnull = null;
int? inull = null;
SqlConnection connection = new SqlConnection();
connection = SQLHelper.GetSQLConnection();
try
{
SqlParameter[] parm = new SqlParameter[6];
parm[0] = new SqlParameter("@TicketID ", SqlDbType.BigInt);
parm[0].Value = Ticketid;
parm[1] = new SqlParameter("@Type", SqlDbType.Char);
parm[1].Value = Type;
reader = SQLHelper.ExecuteReader(connection, CommandType.StoredProcedure, spName, parm);
if (reader.HasRows)
{
while (reader.Read())
{
TicketHistoryinfoResponse sh = new TicketHistoryinfoResponse();
{
if (Type == 'I')
{
sh.Ticket = reader["Ticket"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("Ticket")) : Snull;
sh.CustomerName = reader["CustomerName"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("CustomerName")) : Snull;
sh.HistoryLastUpdated = reader["HistoryLastUpdated"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("HistoryLastUpdated")) : Snull;
sh.TicketOwner = reader["TicketOwner"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("TicketOwner")) : Snull;
sh.TicketOwnerBranch = reader["TicketOwnerBranch"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("TicketOwnerBranch")) : Snull;
sh.TicketCreatedDate = reader["TicketCreatedDate"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("TicketCreatedDate")) : Snull;
sh.TicketStatus = reader["TicketStatus"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("TicketStatus")) : Snull;
sh.Email = reader["Email"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("Email")) : Snull;
sh.Number = reader["Number"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("Number")) : Snull;
sh.FromCustID = reader["CustID"] != DBNull.Value ? Convert.ToInt64(reader["CustID"]) : Lnull;
sh.FromProfileID = reader["ProfileID"] != DBNull.Value ? Convert.ToInt64(reader["ProfileID"]) : Lnull;
sh.TocustID = reader["OppCustID"] != DBNull.Value ? Convert.ToInt64(reader["OppCustID"]) : Lnull;
sh.ToProfileID = reader["OppProfileID"] != DBNull.Value ? Convert.ToInt64(reader["OppProfileID"]) : Lnull;
sh.FromName = reader["Name"] != DBNull.Value ? reader["Name"].ToString() : null;
sh.Toname = reader["OppName"] != DBNull.Value ? reader["OppName"].ToString() : null;
sh.TicketStatusID = reader["TicketStatusID"] != DBNull.Value ? Convert.ToInt32(reader["TicketStatusID"]) : inull;
}
else
{
sh.Body = reader["Body"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("Body")) : Snull;
sh.TicketType = reader["TicketType"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("TicketType")) : Snull;
sh.EmployeeName = reader["EmployeeName"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("EmployeeName")) : Snull;
sh.HistoryDate = reader["HistoryDate"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("HistoryDate")) : Snull;
sh.ContactNumber = reader["ContactNumber"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("ContactNumber")) : Snull;
sh.Relation = reader["Relation"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("Relation")) : Snull;
sh.RelationName = reader["RelationName"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("RelationName")) : Snull;
sh.CallResult = reader["CallResult"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("CallResult")) : Snull;
sh.TicketInfo = reader["TicketInfo"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("TicketInfo")) : Snull;
sh.TicketCreatedDatehistry = reader["TicketCreated"] != DBNull.Value ? (reader.GetDateTime(reader.GetOrdinal("TicketCreated"))).ToString() : Snull;
}
}
details.Add(sh);
}
}
reader.Close();
}
catch (Exception ex)
{
Commonclass.ApplicationErrorLog(spName, Convert.ToString(ex.Message), Ticketid, null, null);
}
finally
{
connection.Close();
//SqlConnection.ClearPool(connection);
//SqlConnection.ClearAllPools();
}
return(details);
}
public List <DashboardRequestChats> DgetCustometExpressIntrestDashBoardchats(long?CustID, int?Status, int iStartIndex, int iEndIndex, string spName)
{
List <DashboardRequestChats> dropdownfilling = new List <DashboardRequestChats>();
SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["KakConnection"].ToString());
connection.Open();
try
{
int? iNULL = null;
Int64? iNULL64 = null;
DateTime?datetimenull = null;
SqlCommand command = new SqlCommand(spName, connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@CustID", CustID);
command.Parameters.AddWithValue("@Status", Status);
command.Parameters.AddWithValue("@i_StartIndex", iStartIndex);
command.Parameters.AddWithValue("@i_EndIndex", iEndIndex);
SqlDataReader reader;
reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
DashboardRequestChats dashboardchats = new DashboardRequestChats
{
ProfileID = (reader["ProfileID"]) != DBNull.Value ? reader.GetInt64(reader.GetOrdinal("ProfileID")) : iNULL64,
Cust_MessageLink_Id = (reader["Cust_MessageLink_Id"]) != DBNull.Value ? reader.GetInt64(reader.GetOrdinal("Cust_MessageLink_Id")) : iNULL64,
Cust_MessageHistory_Id = (reader["Cust_MessageHistory_Id"]) != DBNull.Value ? reader.GetInt64(reader.GetOrdinal("Cust_MessageHistory_Id")) : iNULL64,
NAME = (reader["NAME"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("NAME")) : null,
CustID = (reader["CustID"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("CustID")) : iNULL,
DateOfBirth = (reader["DateOfBirth"]) != DBNull.Value ? reader.GetDateTime(reader.GetOrdinal("DateOfBirth")) : datetimenull,
Age = (reader["Age"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Age")) : iNULL,
CasteID = (reader["CasteID"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("CasteID")) : iNULL,
Caste = (reader["Caste"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("Caste")) : null,
HeightInCentimeters = (reader["HeightInCentimeters"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("HeightInCentimeters")) : null,
Education = (reader["Education"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("Education")) : null,
Profession = (reader["Profession"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("Profession")) : null,
IsAccepted = (reader["IsAccepted"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("IsAccepted")) : iNULL,
Body = (reader["Body"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("Body")) : null,
RequestDate = (reader["RequestDate"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("RequestDate")) : null,
IsReviewd = (reader["IsReviewd"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("IsReviewd")) : iNULL,
ReceiverId = (reader["ReceiverId"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("ReceiverId")) : iNULL,
GenderID = (reader["GenderID"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("GenderID")) : iNULL,
MessageStatusID = (reader["MessageStatusID"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("MessageStatusID")) : iNULL,
COUNT = (reader["COUNT"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("COUNT")) : iNULL,
ViewedFlag = (reader["ViewedFlag"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("ViewedFlag")) : iNULL,
LastRepliedBy = (reader["LastRepliedBy"]) != DBNull.Value ? reader.GetInt64(reader.GetOrdinal("LastRepliedBy")) : iNULL64,
loginCustid = (reader["loginCustid"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("loginCustid")) : iNULL,
Photo = (reader["Photo"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("Photo")) : null,
TotalRows = (reader["TotalRows"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("TotalRows")) : iNULL,
Totalpages = (reader["Totalpages"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Totalpages")) : iNULL
};
dropdownfilling.Add(dashboardchats);
}
}
reader.Close();
}
catch (Exception EX)
{
Commonclass.ApplicationErrorLog(spName, Convert.ToString(EX.Message), CustID, null, null);
}
finally
{
connection.Close();
//SqlConnection.ClearPool(connection);
//SqlConnection.ClearAllPools();
}
return(dropdownfilling);
}
public DashboardClass LandingCountsDal(int?CustID, string TypeOfReport, int pagefrom, int pageto, string spName)
{
DashboardClass land = new DashboardClass();
List <PartnerProfilesLatest> PartnerLi = new List <PartnerProfilesLatest>();
SqlDataReader reader;
DataSet ds = new DataSet();
DataTable dt = new DataTable();
int? inull = null;
bool? bnull = null;
SqlConnection con = null;
Int64? Lnull = null;
List <PersonalInfo> liPerson = new List <PersonalInfo>();
try
{
SqlParameter[] parm = new SqlParameter[6];
parm[0] = new SqlParameter("@custID", SqlDbType.Int);
parm[0].Value = CustID;
parm[1] = new SqlParameter("@TypeOfReport", SqlDbType.VarChar);
parm[1].Value = TypeOfReport;
parm[2] = new SqlParameter("@pagefrom", SqlDbType.Int);
parm[2].Value = pagefrom;
parm[3] = new SqlParameter("@pageto", SqlDbType.Int);
parm[3].Value = pageto;
using (con = new SqlConnection(ConfigurationManager.ConnectionStrings["KakConnection"].ToString()))
{
con.Open();
reader = SQLHelper.ExecuteReader(con, CommandType.StoredProcedure, spName, parm);
if (reader.HasRows)
{
while (reader.Read())
{
LandingPartnerMenu liCount = new LandingPartnerMenu();
{
liCount.SaveSearchCount = reader["SavesSearchCount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("SavesSearchCount")) : inull;
liCount.WhobookmarkedCount = reader["WhoBookmarkedCount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("WhoBookmarkedCount")) : inull;
liCount.MybookMarkedProfCount = reader["BookmarkCount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("BookmarkCount")) : inull;
liCount.RectViewedProfCount = reader["ViewedCount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("ViewedCount")) : inull;
liCount.RectWhoViewedCout = reader["WhoViewedCount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("WhoViewedCount")) : inull;
liCount.IgnoreProfileCount = reader["IgnoreCount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("IgnoreCount")) : inull;
//express and Counts Bind
liCount.ExpressIntSent = reader["ExpressSentCount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("ExpressSentCount")) : inull;
liCount.ExpressIntReceived = reader["ExpressReceiveCount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("ExpressReceiveCount")) : inull;
liCount.ExpressAllcount = reader["ExpressAllcount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("ExpressAllcount")) : inull;
liCount.NewMsgs = reader["NewMessageCount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("NewMessageCount")) : inull;
liCount.TotalMsgs = reader["TotalMessageCount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("TotalMessageCount")) : inull;
liCount.SentPhotoRequestCount = reader["PhotoRequestSentCount"] != DBNull.Value ? Convert.ToInt32(reader.GetString(reader.GetOrdinal("PhotoRequestSentCount"))) : inull;
liCount.SentHoroRequestCount = reader["HoroRequestSentCount"] != DBNull.Value ? Convert.ToInt32(reader.GetString(reader.GetOrdinal("HoroRequestSentCount"))) : inull;
liCount.ReceivedPhotoRequestCount = reader["PhotoRequestReceivedCount"] != DBNull.Value ? Convert.ToInt32(reader.GetString(reader.GetOrdinal("PhotoRequestReceivedCount"))) : inull;
liCount.ReceivedHoroRequestCount = reader["HoroRequestReceivedCount"] != DBNull.Value ? Convert.ToInt32(reader.GetString(reader.GetOrdinal("HoroRequestReceivedCount"))) : inull;
liCount.SentProtectedReply = reader["SentProtectedNewCount"] != DBNull.Value ? Convert.ToInt32(reader.GetString(reader.GetOrdinal("SentProtectedNewCount"))) : inull;
liCount.SentProtectedAccept = reader["SentProtectedAcceptCount"] != DBNull.Value ? Convert.ToInt32(reader.GetString(reader.GetOrdinal("SentProtectedAcceptCount"))) : inull;
liCount.SentProtectedReject = reader["SentProtectedRejectCount"] != DBNull.Value ? Convert.ToInt32(reader.GetString(reader.GetOrdinal("SentProtectedRejectCount"))) : inull;
liCount.ReceivedProtectedNew = reader["ReceivedProtectedNewCount"] != DBNull.Value ? Convert.ToInt32(reader.GetString(reader.GetOrdinal("ReceivedProtectedNewCount"))) : inull;
liCount.ReceivedProtectedAccept = reader["ReceivedProtectedAcceptCount"] != DBNull.Value ? Convert.ToInt32(reader.GetString(reader.GetOrdinal("ReceivedProtectedAcceptCount"))) : inull;
liCount.ReceivedProtectedReject = reader["ReceivedProtectedRejectCount"] != DBNull.Value ? Convert.ToInt32(reader.GetString(reader.GetOrdinal("ReceivedProtectedRejectCount"))) : inull;
land.DashBoardCounts = liCount;
}
}
}
reader.NextResult();
if (reader.HasRows)
{
while (reader.Read())
{
PersonalInfo Pcls = new PersonalInfo();
Pcls.TableName = reader["TableName"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("TableName")) : null;
Pcls.ProfileID = reader["ProfileID"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("ProfileID")) : null;
Pcls.GenderID = reader["GenderID"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("GenderID")) : inull;
Pcls.NAME = reader["NAME"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("NAME")) : null;
Pcls.PaidMember = reader["PaidMember"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("PaidMember")) : inull;
Pcls.ProfileLastModifieddate = reader["ProfileLastModifieddate"] != DBNull.Value ? (reader.GetDateTime(reader.GetOrdinal("ProfileLastModifieddate"))).ToString() : null;
Pcls.PhotoName = reader["PhotoName"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("PhotoName")) : null;
Pcls.PhotoName_Cust = reader["PhotoName_Cust"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("PhotoName_Cust")) : inull;
Pcls.MsgReceivedFrom = reader["MsgReceivedFrom"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("MsgReceivedFrom")) : null;
Pcls.MsgReceivedDate = reader["MsgReceivedDate"] != DBNull.Value ? (reader.GetDateTime(reader.GetOrdinal("MsgReceivedDate"))).ToString() : null;
Pcls.ProfilePhotoName = reader["ProfilePhotoName"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("ProfilePhotoName")) : null;
Pcls.IsReviewed = reader["IsReviewed"] != DBNull.Value ? reader.GetBoolean(reader.GetOrdinal("IsReviewed")) : bnull;
Pcls.IsActive = reader["IsActive"] != DBNull.Value ? reader.GetBoolean(reader.GetOrdinal("IsActive")) : bnull;
Pcls.ProfileBattery = reader["ProfileBattery"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("ProfileBattery")) : inull;
Pcls.EmpID = reader["EmpID"] != DBNull.Value ? reader.GetInt64(reader.GetOrdinal("EmpID")) : Lnull;
Pcls.EmpPhone = reader["EmpPhone"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("EmpPhone")) : null;
Pcls.OfficialContactNumber = reader["OfficialContactNumber"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("OfficialContactNumber")) : null;
Pcls.EmployeeName = reader["EmployeeName"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("EmployeeName")) : null;
Pcls.EmailID = reader["EmailID"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("EmailID")) : null;
Pcls.PhotoViewCount = reader["PhotoViewCount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("PhotoViewCount")) : inull;
Pcls.PartnetPrefernceLastOnemonth = reader["PartnetPrefernceLastOnemonth"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("PartnetPrefernceLastOnemonth")) : inull;
Pcls.Photo = reader["Photo"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("Photo")) : null;
Pcls.MaskDiv = (!string.IsNullOrEmpty(Pcls.ProfilePhotoName) && (Pcls.IsReviewed == true && Pcls.IsActive == true)) ? " " : ((!string.IsNullOrEmpty(Pcls.ProfilePhotoName) && (Pcls.IsReviewed == true || Pcls.IsActive == true)) ? "divCSSclass clearfix" : "cssMaskupload clearfix");
land.PersonalInfo = Pcls;
}
}
reader.NextResult();
if (reader.HasRows)
{
while (reader.Read())
{
PartnerProfilesLatest Partnercls = ReturnPartnerProfilesClass(reader, "Partner");
PartnerLi.Add(Partnercls);
}
land.PartnerProfilesnew = PartnerLi;
}
reader.Close();
}
}
catch (Exception ex)
{
Commonclass.ApplicationErrorLog(spName, Convert.ToString(ex.Message), CustID, null, null);
}
finally
{
con.Close();
//SqlConnection.ClearPool(con);
//SqlConnection.ClearAllPools();
}
return(land);
}
