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);
}
