internal DPMFTPConfigurationEntity GetDPMFTPConfigurationById(int Id) { DPMFTPConfigurationEntity results = new DPMFTPConfigurationEntity(); try { StoredProcedureEntity sproc = new StoredProcedureEntity(); sproc.StoredProcedureName = "dnb.DPMGetFTPConfigurationById"; sproc.StoredProceduresParameter.Add(GetParam("@Id", Id.ToString(), SQLServerDatatype.IntDataType)); DataTable dt; dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc, ""); if (dt != null && dt.Rows.Count > 0) { DPMFTPConfigurationAdapter ta = new DPMFTPConfigurationAdapter(); foreach (DataRow rw in dt.Rows) { results = ta.AdaptItem(rw, dt); } } } catch (Exception) { throw; } return(results); }
internal int DPMInsertUpdateFTPConfiguration(DPMFTPConfigurationEntity obj) { int result = 0; try { var dict = obj.ToDictionary(); StoredProcedureEntity sproc = new StoredProcedureEntity(); sproc.StoredProcedureName = "dnb.DPMInsertUpdateFTPConfiguration"; sproc.StoredProceduresParameter.Add(GetParam("@Id", obj.Id == null ? "0" : Convert.ToString(obj.Id), SQLServerDatatype.IntDataType)); sproc.StoredProceduresParameter.Add(GetParam("@Host", Convert.ToString(obj.Host), SQLServerDatatype.VarcharDataType)); sproc.StoredProceduresParameter.Add(GetParam("@Port", obj.Port == null ? null : Convert.ToString(obj.Port), SQLServerDatatype.IntDataType)); sproc.StoredProceduresParameter.Add(GetParam("@Password", Convert.ToString(obj.Password), SQLServerDatatype.VarcharDataType)); sproc.StoredProceduresParameter.Add(GetParam("@UserName", Convert.ToString(obj.UserName), SQLServerDatatype.VarcharDataType)); result = Convert.ToInt32(sql.ExecuteScalar(CommandType.StoredProcedure, sproc)); } catch (Exception) { throw; } return(result); }
public int DPMInsertUpdateFTPConfiguration(DPMFTPConfigurationEntity obj) { return(rep.DPMInsertUpdateFTPConfiguration(obj)); }