public string sendmailforinvitefriend([FromBody] JObject parameter)
{
//JavaScriptSerializer js = new JavaScriptSerializer();
//string[] persons = js.Deserialize<string[]>(parameter["dataemail"]["email_list_send"].ToString());
emailSendFrined objsendmail = new emailSendFrined();
string result = ""; bool resultSendEmail = false;
bool security_flag = false;
try
{
if ((parameter["tokendata"]["member_id"].ToString() != null || parameter["tokendata"]["member_id"].ToString() != "") && (parameter["tokendata"]["Token"].ToString() != null || parameter["tokendata"]["Token"].ToString() != ""))
{
security_flag = objmasters.securityCheck(parameter["tokendata"]["member_id"].ToString(), parameter["tokendata"]["Token"].ToString());
}
if (parameter["dataemail"]["email_list_send"].ToString() != "")
{
objsendmail = parameter["dataemail"].ToObject <emailSendFrined>();
}
if (security_flag == true)
{
if (objsendmail.email_list_send != null && objsendmail.email_list_send.Length > 0)
{
for (int i = 0; i < objsendmail.email_list_send.Length; i++)
{
resultSendEmail = sendinvitemail(objsendmail.email_list_send[i]);
}
}
}
else
{
return("securityIssue");
}
if (resultSendEmail == true)
{
ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + parameter.ToString() + "status" + "Pass");
return("pass");
}
else
{
ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + parameter.ToString() + "status" + "Fail");
return("fail");
}
}
catch (Exception ex)
{
ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + parameter.ToString() + "status" + ex.StackTrace);
return("fail");
}
//return result;
}
public HttpResponseMessage UploadFile()
{
HttpResponseMessage result = null;
try
{
string path = "";
var filePath = ""; int upldcount = 0; string filenm = "";
var httpRequest = HttpContext.Current.Request;
if (httpRequest["requesttype"] == "profile")
{
path = ConfigurationManager.AppSettings["ProfilePic"].ToString();
}
Dictionary <string, string> array1 = new Dictionary <string, string>();
if (httpRequest.Files.Count > 0)
{
var docfiles = new List <string>();
foreach (string file in httpRequest.Files)
{
var postedFile = httpRequest.Files[file];
if (postedFile.FileName.Trim() != "")
{
//var filePath = HttpContext.Current.Server.MapPath("~/imageFolder/DrvPhoto/" + postedFile.FileName);
filenm = postedFile.FileName;
filenm = filenm.ToString().Substring(0, filenm.IndexOf(".")) + System.DateTime.UtcNow.ToString("yyyyMMddHHmmss") + filenm.ToString().Substring(filenm.IndexOf("."), (filenm.ToString().Length - filenm.IndexOf(".")));
filePath = HttpContext.Current.Server.MapPath(path + filenm);
postedFile.SaveAs(filePath);
docfiles.Add(filePath);
array1[file] = path + filenm;
upldcount++;
}
}
result = Request.CreateResponse(HttpStatusCode.Created, filenm);
}
else
{
result = Request.CreateResponse(HttpStatusCode.BadRequest);
}
}
catch (Exception ex)
{
ServerLog.Log(ex.Message.ToString() + Environment.NewLine + ex.StackTrace);
//ServerLog.Log(ex.InnerException.ToString());
result = Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message);
return(result);
}
return(result);
}
private void OnGetUserInfo(object data)
{
ProtocolData pdata = data as ProtocolData;
CTS_GetUserInfo uinfo = pdata.MData as CTS_GetUserInfo;
int uid = uinfo.MUserId;
try
{
DBUserInfo info = UserMgr.MInstance.GetUserInfoById(uid);
STC_UserInfo stc_userinfo = new STC_UserInfo();
stc_userinfo.MUserName = info.MUserName;
ServerNet.MInstance.SendMsg(pdata.MIpEndPoint, STC_UserInfo.MProtoId, stc_userinfo);
}
catch (Exception exp)
{
ServerLog.Log(string.Format("{0}", exp.Message));
}
}
public string update_password([FromBody] JObject parameter)
{
BLReturnObject objBLReturnObject = new BLReturnObject();
try
{
string pwd = parameter["password"].ToString();
pwd = pwd.Trim();
EncryptPassword encrpt = new EncryptPassword();
string encrpt_password = encrpt.Encrypt(pwd.ToString().Trim());
string member_code = parameter["member_code"].ToString();
DataTable dt = new DataTable();
dt = objmasters.getuserinfo(member_code);
DataRow dr = dt.Rows[0];
dr["password"] = encrpt_password;
objDS_MemberTables.member_master.ImportRow(dr);
objBLReturnObject = objmasters.saveLinkData(objDS_MemberTables, true);
if (objBLReturnObject.ExecutionStatus == 1)
{
ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + parameter.ToString() + "status" + "Pass");
return("pass");
}
else
{
ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + parameter.ToString() + "status" + "Fail");
return("fail");
}
}
catch (Exception ex)
{
ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + parameter.ToString() + "status" + ex.StackTrace);
return("fail");
}
}
private void UpdateReceiveData()
{
while (true)
{
if (ReceiveTickCount < SiArray.Count)
{
warningTimes += 1;
}
else
{
warningTimes = 0;
}
if (warningTimes > 30 && StartWarn)
{
EmailParameterSet model = new EmailParameterSet();
model.SendEmail = "*****@*****.**";
model.SendPwd = "libisrsmpjhqbhgh"; //密码
model.SendSetSmtp = "smtp.qq.com"; //发送的SMTP服务地址 ，每个邮箱的是不一样的。。根据发件人的邮箱来定
model.ConsigneeAddress = "*****@*****.**";
model.ConsigneeTheme = "！！数字平台行情接收器报警！！";
model.ConsigneeHand = "数据行情接收异常";
model.ConsigneeName = "dongnan_chen";
model.SendContent = "数据行情接受器接受数据少于订阅数据数量长达30秒";
string errinfo;
if (model.MailSend(model, out errinfo) == true)
{
Console.WriteLine("邮件发送成功！");
}
else
{
Console.WriteLine(errinfo);
}
}
ServerLog.Log(string.Format("√{0},", ReceiveTickCount), false);
ReceiveTickCount = 0;
Thread.Sleep(1000);
}
}
public string sendmailforfotgotpassword([FromBody] JObject parameter)
{
DataTable dtuniversityDetails = new DataTable();
string result = ""; bool resultSendEmail = false;
dtuniversityDetails = objmasters.forgotpwd(parameter["email_id"].ToString(), parameter["birthdate"].ToString(), parameter["security_question"].ToString(), parameter["question_ans"].ToString());
if (dtuniversityDetails != null)
{
string member_code = dtuniversityDetails.Rows[0]["member_code"].ToString();
resultSendEmail = sendEmailfogot(parameter["email_id"].ToString(), member_code, dtuniversityDetails.Rows[0]["university"].ToString());
}
if (resultSendEmail == true)
{
ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + parameter.ToString() + "status" + "Pass");
return("pass ");
}
else
{
ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + parameter.ToString() + "status" + "Fail");
return("fail");
}
//return result;
}
public override void OnActionExecuting(System.Web.Http.Controllers.HttpActionContext actionContext)
{
ServerLog.Log("新的请求");
ResultMsg resultMsg = null;
var request = actionContext.Request;
string method = request.Method.Method;
string staffid = string.Empty, timestamp = string.Empty, nonce = string.Empty, signature = string.Empty;
if (request.Headers.Contains("staffid"))
{
staffid = HttpUtility.UrlDecode(request.Headers.GetValues("staffid").FirstOrDefault());
}
if (request.Headers.Contains("timestamp"))
{
timestamp = HttpUtility.UrlDecode(request.Headers.GetValues("timestamp").FirstOrDefault());
}
if (request.Headers.Contains("nonce"))
{
nonce = HttpUtility.UrlDecode(request.Headers.GetValues("nonce").FirstOrDefault());
}
if (request.Headers.Contains("signature"))
{
signature = HttpUtility.UrlDecode(request.Headers.GetValues("signature").FirstOrDefault());
}
ServerLog.Log("StaffId:" + staffid);
ServerLog.Log("TimeStamp:" + timestamp);
ServerLog.Log("nonce:" + nonce);
if (string.IsNullOrWhiteSpace(staffid) || string.IsNullOrWhiteSpace(timestamp) || string.IsNullOrWhiteSpace(nonce))
{
resultMsg = new ResultMsg()
{
StatusCode = (int)StatusCodeEnum.ParameterError,
Info = StatusCodeEnum.ParameterError.GetEnumText(),
Data = ""
};
actionContext.Response = HttpResponseExtension.toJson(resultMsg);
base.OnActionExecuting(actionContext);
return;
}
if (actionContext.ActionDescriptor.ActionName.Equals("GetToken"))
{
base.OnActionExecuting(actionContext);
return;
}
//double ts1 = 0;
//double ts2 = (DateTime.UtcNow - new DateTime(1970, 1, 1, 0, 0, 0, 0)).TotalMilliseconds;
//bool timespanvalidate = double.TryParse(timestamp, out ts1);
//double ts = ts2 - ts1;
//bool falg = ts > int.Parse(WebSettingsConfig.UrlExpireTime) * 1000;
//if (falg || (!timespanvalidate))
//{
// resultMsg = new ResultMsg() {
// StatusCode = (int)StatusCodeEnum.URLExpireError,
// Info = StatusCodeEnum.URLExpireError.GetEnumText(),
// Data=""
// };
// actionContext.Response = HttpResponseExtension.toJson(resultMsg);
// base.OnActionExecuting(actionContext);
// return;
//}
Token token = (Token)HttpRuntime.Cache.Get(staffid);
string signtoken = string.Empty;
if (null == HttpRuntime.Cache.Get(staffid))
{
resultMsg = new ResultMsg()
{
StatusCode = (int)StatusCodeEnum.TokenInvalid,
Info = StatusCodeEnum.TokenInvalid.GetEnumText(),
Data = ""
};
actionContext.Response = HttpResponseExtension.toJson(resultMsg);
base.OnActionExecuting(actionContext);
return;
}
signtoken = token.SignToken.ToString();
NameValueCollection form = HttpContext.Current.Request.QueryString;
string data = string.Empty;
switch (method)
{
case "POST":
Stream stream = HttpContext.Current.Request.InputStream;
string responseJson = string.Empty;
StreamReader streamReader = new StreamReader(stream);
data = streamReader.ReadToEnd();
break;
case "GET":
IDictionary <string, string> parameters = new Dictionary <string, string>();
for (int f = 0; f < form.Count; f++)
{
string key = form.Keys[f];
parameters.Add(key, form[key]);
}
IDictionary <string, string> sortedParams = new SortedDictionary <string, string>(parameters);
IEnumerator <KeyValuePair <string, string> > dem = sortedParams.GetEnumerator();
StringBuilder query = new StringBuilder();
while (dem.MoveNext())
{
string key = dem.Current.Key;
string value = dem.Current.Value;
if (!string.IsNullOrWhiteSpace(value))
{
query.Append(key).Append(value);
}
}
data = query.ToString();
break;
default:
resultMsg = new ResultMsg()
{
StatusCode = (int)StatusCodeEnum.HttpMethodError,
Info = StatusCodeEnum.HttpMethodError.GetEnumText(),
Data = ""
};
actionContext.Response = HttpResponseExtension.toJson(resultMsg);
base.OnActionExecuting(actionContext);
return;
}
bool result = SignExtension.Validate(timestamp, nonce, staffid, signtoken, data, signature);
if (!result)
{
resultMsg = new ResultMsg()
{
StatusCode = (int)StatusCodeEnum.HttpRequestError,
Info = StatusCodeEnum.HttpRequestError.GetEnumText(),
Data = ""
};
actionContext.Response = HttpResponseExtension.toJson(resultMsg);
base.OnActionExecuting(actionContext);
return;
}
base.OnActionExecuting(actionContext);
}
public string SaveRelation([FromBody] JObject Parameter)
{
var tempkey = Parameter.Properties().Select(p => p.Name).ToList();
BLReturnObject objBLReturnObject = new BLReturnObject();
Master SvRelation = new Master();
owner_truck_details truck_Owner_data = new owner_truck_details();
driver_truck_detail drivertruck = new driver_truck_detail();
owner_driver_detail ownerDriverData = new owner_driver_detail();
LoginCheck login_data = new LoginCheck();
owner_truck_details ownerTruckDetailData = new owner_truck_details();
if (tempkey.Contains("login_data"))
{
login_data = Parameter["login_data"].ToObject <LoginCheck>();
}
if (tempkey.Contains("truck_owner"))
{
truck_Owner_data = Parameter["truck_owner"].ToObject <owner_truck_details>();
}
if (tempkey.Contains("truck_driver"))
{
drivertruck = Parameter["truck_driver"].ToObject <driver_truck_detail>();
}
if (tempkey.Contains("owner_driver"))
{
ownerDriverData = Parameter["owner_driver"].ToObject <owner_driver_detail>();
}
#region Truck Owner Data
if (truck_Owner_data != null)
{
if (truck_Owner_data.owner_id != null && truck_Owner_data.truck_id != null)
{
try
{
//owid = truck_Owner_data.owner_id;
DS_Truck_Mst.owner_truck_detailsRow owrow = objtruck.owner_truck_details.Newowner_truck_detailsRow();
owrow.owner_id = truck_Owner_data.owner_id;
owrow.truck_id = truck_Owner_data.truck_id;
owrow.active_flag = "Y";
owrow.created_by = login_data.user_id;
owrow.created_date = System.DateTime.UtcNow;
owrow.created_host = "1111";
owrow.device_id = login_data.device_id;
owrow.device_type = login_data.device_type;
objtruck.owner_truck_details.Addowner_truck_detailsRow(owrow);
}
catch (Exception ex)
{
ServerLog.Log("Truck Owner Relation: " + ex.Message.ToString() + ex.StackTrace.ToString());
return(ex.Message.ToString());
}
}
}
#endregion
#region Truck Driver Details
if (drivertruck != null)
{
if (drivertruck.driver_id != null && drivertruck.truck_id != null)
{
try
{
DS_Truck_Mst.driver_truck_detailsRow trkdrvrow = objtruck.driver_truck_details.Newdriver_truck_detailsRow();
trkdrvrow.driver_id = drivertruck.driver_id;
trkdrvrow.truck_id = drivertruck.truck_id;
trkdrvrow.active_flag = "Y";
trkdrvrow.created_by = login_data.user_id;
trkdrvrow.created_date = System.DateTime.UtcNow;
trkdrvrow.created_host = "1111";
trkdrvrow.device_id = login_data.device_id;
trkdrvrow.device_type = login_data.device_type;
objtruck.driver_truck_details.Adddriver_truck_detailsRow(trkdrvrow);
}
catch (Exception ex)
{
ServerLog.Log("Truck Driver Relation : " + ex.Message.ToString());
return(ex.Message.ToString());
}
}
}
#endregion
#region Owner Driver Details
try
{
if (tempkey.Contains("owner_driver"))
{
ownerDriverData = Parameter["owner_driver"].ToObject <owner_driver_detail>();
if (ownerDriverData != null)
{
if (ownerDriverData.owner_id != null && ownerDriverData.driver_id != null)
{
try
{
DS_Owner_Mst.owner_driver_detailsRow owndrvrow = objowner.owner_driver_details.Newowner_driver_detailsRow();
owndrvrow.owner_id = ownerDriverData.owner_id;
owndrvrow.driver_id = ownerDriverData.driver_id;
owndrvrow.active_flag = "Y";
owndrvrow.created_by = login_data.user_id;
owndrvrow.created_date = System.DateTime.UtcNow;
owndrvrow.created_host = "1111";
owndrvrow.device_id = login_data.device_id;
owndrvrow.device_type = login_data.device_type;
objowner.owner_driver_details.Addowner_driver_detailsRow(owndrvrow);
}
catch (Exception ex)
{
ServerLog.Log("Owner Driver Relation: " + ex.Message.ToString());
responsecls.status = "0";
responsecls.Message = ex.Message;
return(jser.Serialize(responsecls));
}
}
}
}
}
catch (Exception ex)
{
ServerLog.Log(ex.Message);
responsecls.status = "0";
responsecls.Message = ex.Message;
return(jser.Serialize(responsecls));
}
#endregion
DataSet[] dsall = new DataSet[2];
dsall[0] = objtruck;
dsall[1] = objowner;
// objBLReturnObject = ownermst.Save_Owner_Mst(objowner, objOwnerDriver);
objBLReturnObject = SvRelation.SaveOwnerTruckDriverRelation(dsall);
if (objBLReturnObject.ExecutionStatus == 1)
{
return(objBLReturnObject.ServerMessage);
}
else
{
ServerLog.Log(objBLReturnObject.ServerMessage.ToString());
return(objBLReturnObject.ServerMessage);
}
}
public String RegisterDeviceAndroid([FromBody] JObject parameter)
{
//ResponseObjectInfo objResponseObjectInfo = new ResponseObjectInfo();
BLReturnObject objBLReturnObject = new BLReturnObject();
String AppName = parameter["AppName"].ToString();
String RepId = parameter["RepId"].ToString();
String DeviceId = parameter["DeviceId"].ToString();
String TokenId = parameter["TokenId"].ToString();
String DeviceInfo = parameter["DeviceInfo"].ToString();
String OS = parameter["OS"].ToString();
String IMEINo = parameter["IMEINo"].ToString();
try
{
ServerLog.Log_QUA((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + parameter.ToString() + "status" + "RegisterDeviceAndroid(" + Convert.ToString(AppName) + ", " + Convert.ToString(RepId) + ", " + Convert.ToString(DeviceId) + ", " + Convert.ToString(TokenId) + ", " + Convert.ToString(DeviceInfo) + ", " + Convert.ToString(OS) + ", " + Convert.ToString(IMEINo) + ")");
// ServerLog.ExceptionLog("RegisterDeviceAndroid(" + Convert.ToString(AppName) + ", " + Convert.ToString(RepId) + ", " + Convert.ToString(DeviceId) + ", " + Convert.ToString(TokenId) + ", " + Convert.ToString(DeviceInfo) + ", " + Convert.ToString(OS) + ", " + Convert.ToString(IMEINo) + ")");
if (AppName == null || AppName.Trim() == String.Empty)
{
objBLReturnObject.ExecutionStatus = 2;
objBLReturnObject.ServerMessage = "Please supplied AppName.";
objBLReturnObject.dt_ReturnedTables = null;
}
else if (RepId == null || RepId.Trim() == String.Empty)
{
objBLReturnObject.ExecutionStatus = 2;
objBLReturnObject.ServerMessage = "Please supplied RepId.";
objBLReturnObject.dt_ReturnedTables = null;
}
else if (DeviceId == null || DeviceId.Trim() == String.Empty)
{
objBLReturnObject.ExecutionStatus = 2;
objBLReturnObject.ServerMessage = "Please supplied DeviceId.";
objBLReturnObject.dt_ReturnedTables = null;
}
else if (TokenId == null || TokenId.Trim() == String.Empty)
{
objBLReturnObject.ExecutionStatus = 2;
objBLReturnObject.ServerMessage = "Please supplied TokenId.";
objBLReturnObject.dt_ReturnedTables = null;
}
else if (OS == null || OS.Trim() == String.Empty)
{
objBLReturnObject.ExecutionStatus = 2;
objBLReturnObject.ServerMessage = "Please supplied OS.";
objBLReturnObject.dt_ReturnedTables = null;
}
else if (IMEINo == null || IMEINo.Trim() == String.Empty)
{
objBLReturnObject.ExecutionStatus = 2;
objBLReturnObject.ServerMessage = "Please supplied IMEINo.";
objBLReturnObject.dt_ReturnedTables = null;
}
else
{
String Message = String.Empty;
Masters objmasters = new Masters();
Byte result = objmasters.AddDeviceInfo(AppName, RepId, DeviceId, TokenId, DeviceInfo, OS, IMEINo, ref Message);
objBLReturnObject.ExecutionStatus = result;
objBLReturnObject.ServerMessage = Message;
objBLReturnObject.dt_ReturnedTables = null;
}
}
catch (Exception ex)
{
objBLReturnObject.ExecutionStatus = 2;
objBLReturnObject.ServerMessage = ex.Message;
objBLReturnObject.dt_ReturnedTables = null;
// ServerLog.ExceptionLog("RegisterDeviceAndroid(" + Convert.ToString(AppName) + ", " + Convert.ToString(RepId) + ", " + Convert.ToString(DeviceId) + ", " + Convert.ToString(TokenId) + ", " + Convert.ToString(DeviceInfo) + ", " + Convert.ToString(OS) + ")");
ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + parameter.ToString() + "status" + ex.StackTrace);
}
return(JsonConvert.SerializeObject(objBLReturnObject));
}
public string SaveAppLog([FromBody] JObject jobj)
{
AppLog jobjdata = new AppLog();
Document doc = new Document();
BLReturnObject objBLReturnObject = new BLReturnObject(); Master master = new Master();
string message = "";
DS_AppLog ds_app = new DS_AppLog();
List <AppLog> tload = new List <AppLog>();
tload = jobj["log"].ToObject <List <AppLog> >();
DataTable dt_log = new DataTable(); string LogDocID = "";
dt_log = BLGeneralUtil.ToDataTable(tload);
try
{
if (jobj != null)
{
if (dt_log != null && dt_log.Rows.Count > 0)
{
DBConnection.Open();
DBCommand.Transaction = DBConnection.BeginTransaction();
ds_app.EnforceConstraints = false;
if (!doc.W_GetNextDocumentNo(ref DBCommand, "APL", "", "", ref LogDocID, ref message)) // New Driver Notification ID
{
return(BLGeneralUtil.return_ajax_string("0", message));
}
ds_app.AppLog.ImportRow(dt_log.Rows[0]);
ds_app.AppLog[0].log_id = LogDocID;
ds_app.AppLog[0].log_date = System.DateTime.UtcNow;
ds_app.AppLog[0].created_date = System.DateTime.UtcNow;
ds_app.AppLog[0].AcceptChanges();
ds_app.AppLog[0].SetAdded();
ds_app.EnforceConstraints = true;
objBLReturnObject = master.UpdateTables(ds_app.AppLog, ref DBCommand);
if (objBLReturnObject.ExecutionStatus != 1)
{
ServerLog.Log(objBLReturnObject.ServerMessage.ToString());
DBCommand.Transaction.Rollback();
if (DBConnection.State == ConnectionState.Open)
{
DBConnection.Close();
}
return(BLGeneralUtil.return_ajax_string("0", objBLReturnObject.ServerMessage));
}
DBCommand.Transaction.Commit();
if (DBConnection.State == ConnectionState.Open)
{
DBConnection.Close();
}
objBLReturnObject.ExecutionStatus = 1;
ServerLog.SuccessLog("App Log Entry Saved : " + LogDocID);
}
}
}
catch (Exception ex)
{
ServerLog.Log(ex.Message + ex.StackTrace);
DBCommand.Transaction.Rollback();
if (DBConnection.State == ConnectionState.Open)
{
DBConnection.Close();
}
return(BLGeneralUtil.return_ajax_string("0", ex.Message));
}
return(BLGeneralUtil.return_ajax_string("1", "App Log Entry Saved : " + LogDocID));
}
public bool SetAndModifyStatusinAnyTableNew(string tablename, string status, string shipperid, string inquiryno, string ownerid, string truckid, string driverid, ref IDbCommand DBCommand)
{
DBCommand.Parameters.Clear();
string where = "";
string query = " UPDATE " + tablename +
" SET status = '" + status + "' " + " WHERE ";
if (shipperid != string.Empty && shipperid != "" && shipperid.TrimEnd() != "")
{
DBCommand.Parameters.Add(BLGeneralUtil.MakeParameter("@shipperid", DbType.String, shipperid));
where = " shipper_id= @shipperid ";
}
if (inquiryno != string.Empty && inquiryno != "" && inquiryno.TrimEnd() != "")
{
DBCommand.Parameters.Add(BLGeneralUtil.MakeParameter("@inquiryno", DbType.String, inquiryno));
if (where != string.Empty)
{
where = where + "AND load_inquiry_no= @inquiryno ";
}
else
{
where = " load_inquiry_no = @inquiryno ";
}
}
if (ownerid != string.Empty && ownerid != "" && ownerid.TrimEnd() != "")
{
DBCommand.Parameters.Add(BLGeneralUtil.MakeParameter("@ownerid", DbType.String, ownerid));
if (where != string.Empty)
{
where = where + "AND owner_id= @ownerid ";
}
else
{
where = " owner_id = @ownerid ";
}
}
if (truckid != string.Empty && truckid != "" && truckid.TrimEnd() != "")
{
DBCommand.Parameters.Add(BLGeneralUtil.MakeParameter("@truckid", DbType.String, truckid));
if (where != string.Empty)
{
where = where + "AND truck_id= @truckid ";
}
else
{
where = " truck_id = @truckid ";
}
}
if (driverid != string.Empty && driverid != "" && driverid.TrimEnd() != "")
{
DBCommand.Parameters.Add(BLGeneralUtil.MakeParameter("@driverid", DbType.String, driverid));
if (where != string.Empty)
{
where = where + "AND driver_id= @driverid ";
}
else
{
where = " driver_id = @driverid ";
}
}
query = query + where;
DBCommand.CommandText = query;
int row_count = 0;
if (DBConnection.State == ConnectionState.Closed)
{
DBConnection.Open();
}
try
{
row_count = DBCommand.ExecuteNonQuery();
}
catch (Exception ex)
{
ServerLog.Log(ex.Message + Environment.NewLine + ex.StackTrace);
return(false);
}
if (row_count <= 0)
{
ServerLog.Log("Status not Updated " + tablename + Environment.NewLine + query);
return(false);
}
else
{
return(true);
}
}
public string LoginCheck([FromBody] LoginData loginData)
{
int flg = 0;
BLReturnObject objBLReturnObject = new BLReturnObject();
DataTable dtMemberDetails = new DataTable();
string result = "";
string encrpt_password = "";
dtMemberDetails = objmasters.LoginCheck(loginData.userName);
try
{
ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + loginData.dives + " " + loginData.password + " " + loginData.userName + "status" + "pass");
if (dtMemberDetails == null || dtMemberDetails.Rows.Count == 0)
{
ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + loginData.ToString() + "status" + "NotExists");
return("NotExists");
}
if (dtMemberDetails.Rows[0]["university"].ToString() != loginData.university_id)
{
ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + loginData.ToString() + "status" + "Wronguniversity");
return("Wronguniversity");
}
else
{
if (loginData.pass_encrpted_flag != "true")
{
loginData.password = loginData.password.Trim();
EncryptPassword encrpt = new EncryptPassword();
encrpt_password = encrpt.Encrypt(loginData.password.ToString().Trim());
}
else
{
encrpt_password = loginData.password;
}
if (dtMemberDetails.Rows[0]["password"].ToString() != encrpt_password)
{
ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + loginData.ToString() + "status" + "WrongPass");
return("WrongPass");
}
if (dtMemberDetails.Rows[0]["default_role"].ToString() == "TT")
{
DataTable dtrole = objmasters.checkmemberrole(loginData.userName);
for (int i = 0; i < dtrole.Rows.Count; i++)
{
if (dtrole.Rows[i]["role_id"].ToString() == "ST")
{
break;
}
else if (dtrole.Rows[i]["role_id"].ToString() == "TT")
{
if (dtrole.Rows[i]["is_approved"].ToString() == "Y" && dtrole.Rows[i]["approved_by_whome"].ToString() != "" && dtrole.Rows[i]["approved_by_whome"].ToString() != null)
{
break;
}
else
{
flg++;
}
}
}
if (dtrole.Rows.Count == flg)
{
ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + loginData.ToString() + "status" + "notApproved");
return("notApproved");
}
}
//Random rand = new Random();
//int tokenId = rand.Next(1, 100000);
Guid tokenId = Guid.NewGuid();
DataRow dr = dtMemberDetails.Rows[0];
//dr["token_id"] = tokenId.ToString();
objDS_MemberTables.member_master.ImportRow(dr);
DS_MemberTables.login_tokenRow rowtoken = objDS_MemberTables.login_token.Newlogin_tokenRow();
rowtoken.member_id = loginData.userName;
rowtoken.device_id = loginData.dives;
rowtoken.token_id = tokenId.ToString();
if (rowtoken.device_id.Trim().Length == 0)
{
ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + loginData.ToString() + "status" + "Device not null");
return("Device not null");
}
else
{
objDS_MemberTables.login_token.Addlogin_tokenRow(rowtoken);
objBLReturnObject = objmasters.saveLinkData_login(objDS_MemberTables, true);
if (objBLReturnObject.ExecutionStatus == 1)
{
dtMemberDetails.Columns.Add("token_id");
dtMemberDetails.Rows[0]["token_id"] = tokenId.ToString();;
result = GetJson1(dtMemberDetails);
}
else
{
ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + loginData.ToString() + "status" + "TokenIssue");
return("TokenIssue");
}
}
}
}
catch (Exception e)
{
ServerLog.Log((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + loginData.ToString() + "status" + e.StackTrace);
return(result);
}
return(result);
}
