public object SaveParameter(string args, string role) { JsonResponse response = new JsonResponse(); //if (token == CurrentToken()) //{ BllLogin bl = new BllLogin(); LoginAtt ll = JsonUtility.DeSerialize(args, typeof(LoginAtt)) as LoginAtt; // response.Message = bl.SaveParameter(ll, role); try { response.Message = bl.SaveParameter(ll, role); if (response.Message != "") { response.IsSucess = false; } else { response.IsSucess = true; } } catch (Exception ex) { response.Message = ex.Message; response.IsSucess = false; } return(JsonUtility.Serialize(response)); }
public List <LoginAtt> GetUser() { List <LoginAtt> lst = new List <LoginAtt>(); try { string msg = ""; char status; SqlCommand oCommand = new SqlCommand(); oCommand.CommandType = CommandType.StoredProcedure; oCommand.CommandText = "getUser"; SqlParameter[] objParameter = new SqlParameter[2]; SqlDataReader dr = SqlHelper.SingleExecuteReader(oCommand); while (dr.Read()) { LoginAtt obj = new LoginAtt(); obj.ID = Convert.ToInt32(dr["ID"].ToString()); obj.UserName = dr["UserName"].ToString(); obj.Address = dr["Address"].ToString(); obj.Password = dr["Password"].ToString(); lst.Add(obj); } //else //{ // msg = " कुनै डाटा छैन!!!"; //} return(lst); } catch (Exception ex) { throw new Exception(ex.Message); } }
public string SaveParameter(LoginAtt obj, string role) { try { LoginDll dllparameter = new LoginDll(); return(dllparameter.SaveParameter(obj, role)); } catch (Exception ex) { throw (ex); } }
public string SaveParameter(LoginAtt objCampaignParameter, string role) { string SP = ""; string msg = ""; char status; SqlCommand oCommand = new SqlCommand(); oCommand.CommandType = CommandType.StoredProcedure; oCommand.CommandText = "mt_login"; SqlParameter[] objParameter = new SqlParameter[2]; objParameter[0] = new SqlParameter("@username", objCampaignParameter.UserName); objParameter[1] = new SqlParameter("@password", objCampaignParameter.Password); // objParameter[2] = new SqlParameter("@submitteddate", "2018.01.07"); // objParameter[3] = new SqlParameter("@submittebBy", "Admin"); SqlDataReader dr = SqlHelper.ExecuteReader(oCommand, objParameter); if (dr.HasRows) { msg = ""; } else { msg = " कुनै डाटा छैन!!!"; } //while (dr.Read()) //{ // string col = dr["UserName"].ToString(); //} //GetConnection conn = new GetConnection(); //OracleConnection dbConn = conn.GetDbConn(role); //OracleTransaction tran = dbConn.BeginTransaction(); //try //{ // if (objCampaignParameter.Status == true) // { // status = 'A'; // } // else // { // status = 'I'; // } // if (objCampaignParameter.Action == "E") // { // SP = "EPR_EDIT_ELECTION_CP_PARAMETER"; // msg = "सफलतापूर्वक रकम अद्यावधिक भयो ।"; // } // else // { // SP = "EPR_ADD_ELECTION_CP_PARAMETER"; // msg = "सफलतापूर्वक सेव भयो ।"; // } // if (SP != "") // { // List<OracleParameter> paramList = new List<OracleParameter>(); // paramList.Add(SqlHelper.GetOraParam(":P_ELECTION_ID", objCampaignParameter.ElectionID, OracleDbType.Int32, ParameterDirection.InputOutput)); // paramList.Add(SqlHelper.GetOraParam(":P_EC_LEVEL_ID", objCampaignParameter.EcLevelID, OracleDbType.Int32, ParameterDirection.Input)); // paramList.Add(SqlHelper.GetOraParam(":P_CP_ID", objCampaignParameter.CPID, OracleDbType.Int32, ParameterDirection.Input)); // paramList.Add(SqlHelper.GetOraParam(":P_CP_VALUES", objCampaignParameter.CPValues, OracleDbType.Varchar2, ParameterDirection.Input)); // paramList.Add(SqlHelper.GetOraParam(":P_R_STATUS", status, OracleDbType.Char, ParameterDirection.Input)); // paramList.Add(SqlHelper.GetOraParam(":P_ENTRY_BY", objCampaignParameter.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input)); // SqlHelper.ExecuteNonQuery(tran, CommandType.StoredProcedure, SP, paramList.ToArray()); // } // tran.Commit(); //} //catch (Exception ex) //{ // tran.Rollback(); // throw new Exception("Error" + ex.Message); //} //finally //{ // dbConn.Close(); // //conn.CloseDbConn(); //} return(msg); }