public static DbStatusEntity[] UpdateClientCredentials(ClientCredentialsEntity obj) { var details = new List <DbStatusEntity>(); try { details.Add(new ClientMasterDAO().UpdateClientCredentials(obj)); } catch (Exception ex) { details.Clear(); details.Add(new DbStatusEntity(ex.Message)); } return(details.ToArray()); }
public DbStatusEntity UpdateClientCredentials(ClientCredentialsEntity obj) { DbStatusEntity objreturn = new DbStatusEntity(); string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; try { using (SqlConnection con = new SqlConnection(CS)) { SqlCommand cmd = new SqlCommand("USP_UpdateClientCredentials", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ID", obj.ID); cmd.Parameters.AddWithValue("@CLIENT_ID", obj.CLIENT_ID); cmd.Parameters.AddWithValue("@SITE_NAME", obj.SITE_NAME); cmd.Parameters.AddWithValue("@URL", obj.URL); cmd.Parameters.AddWithValue("@UNAME", obj.UNAME); cmd.Parameters.AddWithValue("@UPASS", obj.UPASS); cmd.Parameters.AddWithValue("@REMARKS", obj.REMARKS); cmd.Parameters.Add("@RESULT", SqlDbType.Int); cmd.Parameters["@RESULT"].Direction = ParameterDirection.Output; cmd.Parameters.Add("@CNT", SqlDbType.Int); cmd.Parameters["@CNT"].Direction = ParameterDirection.Output; cmd.Parameters.Add("@MSG", SqlDbType.NVarChar, 500); cmd.Parameters["@MSG"].Direction = ParameterDirection.Output; con.Open(); cmd.ExecuteNonQuery(); objreturn.RESULT = Convert.ToInt32(cmd.Parameters["@RESULT"].Value); objreturn.CNT = Convert.ToInt32(cmd.Parameters["@CNT"].Value); objreturn.MSG = Convert.ToString(cmd.Parameters["@MSG"].Value); con.Close(); } } catch (Exception ex) { throw ex; } return(objreturn); }
public List <ClientCredentialsEntity> GetClientCredentialsByID(long id) { string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; SqlDataAdapter adapter; DataSet ds = new DataSet(); List <ClientCredentialsEntity> retlst = new List <ClientCredentialsEntity>(); try { using (SqlConnection con = new SqlConnection(CS)) { SqlCommand cmd = new SqlCommand("USP_GetClientCredentialsbyID", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ID", id); con.Open(); adapter = new SqlDataAdapter(cmd); adapter.Fill(ds); for (int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++) { ClientCredentialsEntity obj = new ClientCredentialsEntity(); obj.ID = ds.Tables[0].Rows[i]["ID"] == DBNull.Value ? 0 : Convert.ToInt64(ds.Tables[0].Rows[i]["ID"].ToString()); obj.CLIENT_ID = ds.Tables[0].Rows[i]["CLIENT_ID"] == DBNull.Value ? 0 : Convert.ToInt64(ds.Tables[0].Rows[i]["CLIENT_ID"].ToString()); obj.SITE_NAME = ds.Tables[0].Rows[i]["SITE_NAME"] == DBNull.Value ? "" : ds.Tables[0].Rows[i]["SITE_NAME"].ToString(); obj.URL = ds.Tables[0].Rows[i]["URL"] == DBNull.Value ? "" : ds.Tables[0].Rows[i]["URL"].ToString(); obj.UNAME = ds.Tables[0].Rows[i]["UNAME"] == DBNull.Value ? "" : ds.Tables[0].Rows[i]["UNAME"].ToString(); obj.UPASS = ds.Tables[0].Rows[i]["UPASS"] == DBNull.Value ? "" : ds.Tables[0].Rows[i]["UPASS"].ToString(); obj.REMARKS = ds.Tables[0].Rows[i]["REMARKS"] == DBNull.Value ? "" : Convert.ToString(ds.Tables[0].Rows[i]["REMARKS"]); retlst.Add(obj); } } } catch (Exception ex) { throw ex; } return(retlst); }