public DataSet GetSubCont(int grval) { try { ____logconfig.Log_Write(____logconfig.LogLevel.INFO, 82, "BL:GetSubCont()::Function starts here."); string sqlstmt = "select contacts from comgt where GroupId=?comgt.groupid"; string[] arr_val = { grval.ToString() }; ____logconfig.Log_Write(____logconfig.LogLevel.DB, 85, "BL:GetSubCont()::query to select contacts from comgt:" + sqlstmt); DataSet ds = DL.DL_ExecuteQuery(sqlstmt, arr_val); ____logconfig.Log_Write(____logconfig.LogLevel.DB, 87, "BL:GetSubCont()::Result of query to select contacts from comgt, no of rows:" + ds.Tables[0].Rows.Count.ToString()); if (ds.Tables[0].Rows.Count > 0) { return(ds); } else { return(null); } } catch (Exception ex) { ____logconfig.Error_Write(____logconfig.LogLevel.EXC, 99, ex.Message.ToString(), "BL"); return(null); } }
public DataSet GetAllGroup(System.Web.UI.WebControls.ListItem listItem) { try { ____logconfig.Log_Write(____logconfig.LogLevel.INFO, 62, "BL:GetAllGroup()::Function starts here."); string sqlstmt = "select * from comgt where GroupName=?global.username"; string[] arr = new string[] { listItem.ToString() }; ____logconfig.Log_Write(____logconfig.LogLevel.DB, 65, "BL:GetAllGroup()::Query to select from comgt:" + sqlstmt); DataSet dr = DL.DL_ExecuteQuery(sqlstmt, arr); ____logconfig.Log_Write(____logconfig.LogLevel.DB, 67, "BL:GetAllGroup()::Result of query to select from comgt, no of rows:" + dr.Tables[0].Rows.Count.ToString()); return(dr); } catch (Exception ex) { ____logconfig.Error_Write(____logconfig.LogLevel.EXC, 72, ex.Message.ToString(), "BL"); return(null); } }
public DataSet GetFilterValue(string cellval) { try { ____logconfig.Log_Write(____logconfig.LogLevel.INFO, 40, "BL:GetFilterValue()::Function starts here."); string sqlstmt = "select * from comgt where GroupId=?grps.groupid"; string[] arr = new string[] { cellval }; ____logconfig.Log_Write(____logconfig.LogLevel.DB, 43, "BL:GetFilterValue()::Query to select from comgt:" + sqlstmt); DataSet dr = DL.DL_ExecuteQuery(sqlstmt, arr); ____logconfig.Log_Write(____logconfig.LogLevel.DB, 45, "BL:GetFilterValue()::Result of query to select from comgt, no of rows:" + dr.Tables[0].Rows.Count.ToString()); return(dr); } catch (Exception ex) { ____logconfig.Error_Write(____logconfig.LogLevel.EXC, 50, ex.Message.ToString(), "BL"); return(null); } }
public DataSet GetGroupList(string unm) { try { ____logconfig.Log_Write(____logconfig.LogLevel.INFO, 18, "BL:GetGroupList()::Function starts here."); //string sqlstmt = "select g.GroupName, g.GroupId,count(c.contacts) as No.of Contacts from comgt c,groups g where c.GroupID=g.GroupID and g.UserName=?global.username group by g.Groupname"; string str_getgroupid = "select GroupID from groups where UserName=?global.username;"; string[] arr_groupid = new string[] { unm }; DataSet ds_groupid = DL.DL_ExecuteQuery(str_getgroupid, arr_groupid); List <string> lstgroupid = new List <string>(); if (ds_groupid != null && ds_groupid.Tables[0].Rows.Count > 0) { foreach (DataRow dr_groupid in ds_groupid.Tables[0].Rows) { lstgroupid.Add(dr_groupid["GroupID"].ToString()); } } DataSet dr; if (lstgroupid.Count > 0) { //string sqlstmt = "select g.GroupName, g.GroupId,count(c.contacts) as Contacts from comgt c,groups g where c.GroupID=g.GroupID and g.UserName=?global.username group by g.Groupname"; string sqlstmt = "select g.GroupName, g.GroupId,count(c.cid) as Contacts from comgt c inner join groups g on c.GroupID=g.GroupID where g.GroupId in (" + string.Join(",", lstgroupid) + ") group by g.GroupId;"; string[] arr = new string[] { unm }; ____logconfig.Log_Write(____logconfig.LogLevel.DB, 22, "BL:GetGroupList()::Query to select group details:" + sqlstmt); dr = DL.DL_ExecuteSimpleQuery(sqlstmt); ____logconfig.Log_Write(____logconfig.LogLevel.DB, 24, "BL:GetGroupList()::Result of query to select group details, no of rows:" + dr.Tables[0].Rows.Count.ToString()); } else { dr = null; } return(dr); } catch (Exception ex) { ____logconfig.Error_Write(____logconfig.LogLevel.EXC, 29, ex.Message.ToString(), "BL"); return(null); } }
protected void Page_Load(object sender, EventArgs e) { string username = ""; string password = ""; string mobileno = ""; string senderid = ""; string cdmaheader = ""; string message = ""; try { if (this.Request.HttpMethod == "GET") { username = this.Request.QueryString["UserName"]; password = this.Request.QueryString["password"]; mobileno = this.Request.QueryString["MobileNo"]; senderid = this.Request.QueryString["SenderID"]; cdmaheader = senderid; message = this.Request.QueryString["Message"]; } if (this.Request.HttpMethod == "POST") { username = this.Request.Form["UserName"]; password = this.Request.Form["password"]; mobileno = this.Request.Form["MobileNo"]; senderid = this.Request.Form["SenderID"]; cdmaheader = senderid; message = this.Request.Form["Message"]; } if (username == null || password == null || (mobileno == null || senderid == null) || message == null) { this.Response.Write("Code=0 SendSMS Pageload"); } else { //var res = Util.ValidateMobileNumbers(mobileno); ____logconfig.Log_Write(____logconfig.LogLevel.DEBUG, 77, "username==>" + username + "password==>" + password + "mobileno===>" + mobileno + "semderID===>" + senderid + "cdmaheader==>" + cdmaheader + "message==>" + message); var sql = "select user_id,username,passkey,Activated from user_master where username like binary ?global.username and passkey like binary ?global.passkey"; var param = new string[2] { username, password }; DataSet dataSet = DL.DL_ExecuteQuery(sql, param); if (dataSet.Tables[0].Rows.Count > 0) { var userId = dataSet.Tables[0].Rows[0]["user_id"].ToString(); string messageid = dataSet.Tables[0].Rows[0]["username"].ToString() + "-" + this.GenerateId(); var isUnicode = Util.ContainsUnicodeCharacter(message); if (dataSet.Tables[0].Rows[0]["Activated"].ToString() == "1") { Dictionary <string, string> dictionary = new Dictionary <string, string>(); foreach (string key in mobileno.Split(',')) { var validatedMobileNo = Util.ValidateMobileNumbers(key); if (validatedMobileNo != "" && !dictionary.ContainsKey(validatedMobileNo)) { dictionary.Add(validatedMobileNo, validatedMobileNo); } } if (dictionary.Count != 0) { string mobile_no = string.Join(",", dictionary.Keys.ToList <string>()); if (cdmaheader == null) { cdmaheader = senderid; } if (isUnicode) { int num = importnum.importdata(username, password, senderid, cdmaheader, message, mobileno, messageid, 2); if (num > 0) { this.Response.Write("MessageSent GUID=\"" + messageid + "\" SUBMITDATE=\"" + DateTime.Now.GetDateTimeFormats()[84] + "\""); } else { this.Response.Write("Code=0 SendSMS Pageload"); } } else if (Util.MatchTemplate(username, senderid, message)) { int num = importnum.importdata(username, password, senderid, cdmaheader, message, mobileno, messageid, 0); if (num > 0) { this.Response.Write("MessageSent GUID=\"" + messageid + "\" SUBMITDATE=\"" + DateTime.Now.GetDateTimeFormats()[84] + "\""); } else { this.Response.Write("Code=0 SendSMS Pageload"); } } else { importnum.ImportInvalidRequest(userId, username, messageid, senderid, message, DateTime.Now.ToString("yyyyMMddHHmmss"), mobileno, "TEMPLATE FAILED.", isUnicode ? "2" : "", 1); this.Response.Write("Code=0 Template Matching failed"); } } else { importnum.ImportInvalidRequest(userId, username, messageid, senderid, message, DateTime.Now.ToString("yyyyMMddHHmmss"), mobileno, "INVALID MOBILE FAILED.", isUnicode ? "2" : "", 2); Response.Write("Code=0 Invalid Mobile Number"); } } else { importnum.ImportInvalidRequest(userId, username, messageid, senderid, message, DateTime.Now.ToString("yyyyMMddHHmmss"), mobileno, "USED DEACTIVE FAILED.", isUnicode ? "2" : "", 3); this.Response.Write("Code=0 User Account De-Activated"); } } else { this.Response.Write("Invalid username or password"); } } } catch (Exception ex) { this.Response.Write("Code=0 Internal exception occured"); this.errorlogs.WriteAsync("exception.txt", DateTime.Now.ToString() + "On SMSSUBMIT Page Main method" + ex.ToString()); } }