public User LoginUser(string UserName, string UserPassword) { DataSet dsList = new DataSet(); CoreSQLConnection CoreSQL = new CoreSQLConnection(); User model = new User(); try { if (UserName != null && UserPassword != null) { if (UserName.Trim() != "" && UserPassword.Trim() != "") { String strQuery = "http://203.80.189.18:5190/acl.sales/LoginUser/GetUserList"; dsList = CoreSQL.CoreSQL_GetDataSet(strQuery); dsList.Tables[0].TableName = "Login"; foreach (DataRow row in dsList.Tables[0].Rows) { if (row[2].ToString() == UserPassword) { model.prcSetData(row); return(model); } } } } return(null); } catch (Exception ex) { throw (ex); } finally { } }
public string GetFuelList(string searchdata) { var userid = _httpContextAccessor.HttpContext.User.GetLoggedInUserId <string>(); CoreSQLConnection CoreSQL = new CoreSQLConnection(); string strQuery = "Exec [prcDynamic_FuelList] @userId = '" + userid + "', @SearchData ='" + searchdata + "' "; dsList = CoreSQL.CoreSQL_GetDataSet(strQuery); return(clsCommon.JsonSerialize(dsList.Tables[0])); }
public string GetConveyType() { CoreSQLConnection CoreSQL = new CoreSQLConnection(); DataSet dsList = new DataSet(); string strQuery = "Exec [prcGet_ConveyanceType]"; dsList = CoreSQL.CoreSQL_GetDataSet(strQuery); return(clsCommon.JsonSerialize(dsList.Tables[0])); }
public string GetConveyInfo(int visitid) { CoreSQLConnection CoreSQL = new CoreSQLConnection(); DataSet dsList = new DataSet(); string strQuery = "Exec [prcGet_ConveyData] " + visitid; dsList = CoreSQL.CoreSQL_GetDataSet(strQuery); return(clsCommon.JsonSerialize(dsList.Tables[0])); }
public string GetJsonUserList() { CoreSQLConnection CoreSQL = new CoreSQLConnection(); DataSet dsList = new DataSet(); string strQuery = "exec [prcGet_UserList] "; dsList = CoreSQL.CoreSQL_GetDataSet(strQuery); return(clsCommon.JsonSerialize(dsList.Tables[0])); }
public string GetVisitDetailsByLocCustId(int id) { CoreSQLConnection CoreSQL = new CoreSQLConnection(); DataSet dsList = new DataSet(); string strQuery = "Exec [prcGet_VisitDetails] '" + id + "' "; dsList = CoreSQL.CoreSQL_GetDataSet(strQuery); return(clsCommon.JsonSerialize(dsList.Tables[0])); }
public string GetUser() { DataSet dsList = new DataSet(); CoreSQLConnection CoreSQL = new CoreSQLConnection(); string strQuery = "Exec prcGetValidateLogin"; dsList = CoreSQL.CoreSQL_GetDataSet(strQuery); return(clsCommon.JsonSerialize(dsList.Tables[0])); }
public string GetProductList() { CoreSQLConnection CoreSQL = new CoreSQLConnection(); dsList = new DataSet(); string strQuery = "Exec [prcGet_ProductList] 2"; dsList = CoreSQL.CoreSQL_GetDataSet(strQuery); return(clsCommon.JsonSerialize(dsList.Tables[0])); }
public string GetCustomerById(int id) { CoreSQLConnection CoreSQL = new CoreSQLConnection(); dsList = new DataSet(); string strQuery = "Exec prcGet_Customer '" + id + "' "; dsList = CoreSQL.CoreSQL_GetDataSet(strQuery); return(clsCommon.JsonSerialize(dsList.Tables[0])); }
public string GetCustomer(string searchdata) { CoreSQLConnection CoreSQL = new CoreSQLConnection(); dsList = new DataSet(); string strQuery = "Exec [prcGet_CustomerBySearch] " + searchdata; dsList = CoreSQL.CoreSQL_GetDataSet(strQuery); return(clsCommon.JsonSerialize(dsList.Tables[0])); }
public string GetUnit() { CoreSQLConnection CoreSQL = new CoreSQLConnection(); dsList = new DataSet(); string strQuery = "Exec [prcGetUnit] '" + ComId + "', 0 "; dsList = CoreSQL.CoreSQL_GetDataSet(strQuery); return(clsCommon.JsonSerialize(dsList.Tables[0])); }
public string GetProduct(int Productid) { CoreSQLConnection CoreSQL = new CoreSQLConnection(); dsList = new DataSet(); string strQuery = "Exec [prcGet_Product] 0,'" + Productid + "' "; dsList = CoreSQL.CoreSQL_GetDataSet(strQuery); return(clsCommon.JsonSerializeDataSet(dsList)); }
public string GetVisitCustomerList(string pageindex, string pagesize, string searchdata) { var userid = _httpContextAccessor.HttpContext.User.GetLoggedInUserId <string>(); CoreSQLConnection CoreSQL = new CoreSQLConnection(); DataSet dsList = new DataSet(); string strQuery = "Exec [prcDynamic_search_Assignment1] @PageIndex = '" + pageindex + "', @PageSize = '" + pagesize + "', @Name = '" + searchdata + "' , @OrderBy ='Name' "; dsList = CoreSQL.CoreSQL_GetDataSet(strQuery); return(clsCommon.JsonSerialize(dsList.Tables[0])); }
public string GetCombo() { CoreSQLConnection CoreSQL = new CoreSQLConnection(); dsList = new DataSet(); string strQuery = "Exec [prcGet_Supplier] 0,0"; dsList = CoreSQL.CoreSQL_GetDataSet(strQuery); return(clsCommon.JsonSerialize(dsList.Tables[1])); }
public string GetSupplierById(int supplierid) { CoreSQLConnection CoreSQL = new CoreSQLConnection(); dsList = new DataSet(); string strQuery = "Exec [prcGet_Supplier] 0,'" + supplierid + "' "; dsList = CoreSQL.CoreSQL_GetDataSet(strQuery); return(clsCommon.JsonSerialize(dsList.Tables[0])); }
public string GetAllVisitCustomerList(string searchdata, string custtype, string dtfrom, string dtto) { var userid = _httpContextAccessor.HttpContext.User.GetLoggedInUserId <string>(); CoreSQLConnection CoreSQL = new CoreSQLConnection(); DataSet dsList = new DataSet(); if (string.IsNullOrEmpty(userid)) { throw new InvalidOperationException("User Not found"); } string strQuery = "Exec [prcGet_VisitCustomerList] @UserId = '" + userid + "', @Name = '" + searchdata + "', @Type = '" + custtype + "', @dtFrom = '" + dtfrom + "', @dtTo='" + dtto + "'"; dsList = CoreSQL.CoreSQL_GetDataSet(strQuery); return(clsCommon.JsonSerialize(dsList.Tables[0])); }
public string GetTotalVisitDay() { var userid = _httpContextAccessor.HttpContext.User.GetLoggedInUserId <string>(); if (string.IsNullOrEmpty(userid)) { throw new InvalidOperationException("User Not found"); } CoreSQLConnection CoreSQL = new CoreSQLConnection(); dsList = new DataSet(); string strQuery = "Exec [prcGet_DayVisit] '" + userid + "' "; dsList = CoreSQL.CoreSQL_GetDataSet(strQuery); return(clsCommon.JsonSerialize(dsList.Tables[0])); }
public User LoginUser(string UserName, string UserPassword) { DataSet dsList = new DataSet(); CoreSQLConnection CoreSQL = new CoreSQLConnection(); User model = new User(); try { if (UserName != null && UserPassword != null) { if (UserName.Trim() != "" && UserPassword.Trim() != "") { String strQuery = "Exec prcGetValidateLogin '" + UserName.ToLower() + "'"; dsList = CoreSQL.CoreSQL_GetDataSet(strQuery); dsList.Tables[0].TableName = "Login"; foreach (DataRow row in dsList.Tables[0].Rows) { if (CoreSQL.GetDecryptedData(row[2].ToString()) == UserPassword) { model.prcSetData(row); model.UserPassword = CoreSQL.GetDecryptedData(model.UserPassword); return(model); } } } } return(null); } catch (Exception ex) { throw (ex); } finally { } }