protected void Page_Load(object sender, EventArgs e)
{
AppData appData = AppData.GetAppData();
UserData userData = UserData.GetUserData();
// проверка входа в систему
if (!userData.LoggedOn)
{
throw new ScadaException(WebPhrases.NotLoggedOn);
}
// получение параметров запроса
int[] cnlNums = Request.QueryString.GetParamAsIntArray("cnlNums");
int[] viewIDs = Request.QueryString.GetParamAsIntArray("viewIDs");
DateTime startDate = Request.QueryString.GetParamAsDate();
int period = Request.QueryString.GetParamAsInt("period");
// проверка прав и получение представления, если оно единственное
RightsChecker rightsChecker = new RightsChecker(appData.ViewCache);
BaseView singleView;
rightsChecker.CheckRights(userData, cnlNums, viewIDs, out singleView);
string viewTitle = singleView == null ? "" : singleView.Title;
// генерация отчёта
RepBuilder repBuilder = new MinDataRepBuilder(appData.DataAccess);
RepUtils.WriteGenerationAction(appData.Log, repBuilder, userData);
RepUtils.GenerateReport(
repBuilder,
new object[] { cnlNums, startDate, period, viewTitle },
Server.MapPath("~/plugins/Chart/templates/"),
RepUtils.BuildFileName("MinData", "xml"),
Response);
}
private List <MRole> getList(List <DataFilters> filters)
{
List <MRole> obj = new List <MRole>();
using (NpgsqlConnection conn = GetConnection())
{
using (NpgsqlCommand com = new NpgsqlCommand())
{
using (NpgsqlDataAdapter oDA = new NpgsqlDataAdapter())
{
using (DataTable dt = new DataTable())
{
conn.Open();
com.Connection = conn;
com.CommandTimeout = conn.ConnectionTimeout;
oDA.SelectCommand = com;
com.CommandText = "select mrole.*" +
" from mrole where 1=1";
RepSqlDatabase.OperatorSQL(com, filters);
oDA.Fill(dt);
obj = (from DataRow x in dt.Rows
select new MRole()
{
id = RepUtils.NullToInt(x["id"]),
role = RepUtils.NullToStr(x["role"]),
issupervisor = RepUtils.NullToBool(x["issupervisor"])
}).ToList();
}
}
}
}
return(obj);
}
private List <MJenisTransaksiD> getDetil(NpgsqlCommand com, NpgsqlDataAdapter oDA, long header)
{
List <MJenisTransaksiD> detil = new List <MJenisTransaksiD>();
com.CommandText = "select * from mjenistransaksid where idjenistransaksi=@noid";
com.Parameters.Clear();
com.Parameters.AddWithValue("@noid", header);
using (DataTable dt = new DataTable())
{
oDA.SelectCommand = com;
oDA.Fill(dt);
detil = (from DataRow x in dt.Rows
select new MJenisTransaksiD()
{
nourut = RepUtils.NullToInt(x["nourut"]),
idjenistransaksi = RepUtils.NullToLong(x["idjenistransaksi"]),
digit = RepUtils.NullToInt(x["digit"]),
format = RepUtils.NullToStr(x["format"]),
jenis = RepUtils.NullToStr(x["jenis"]),
prefix = RepUtils.NullToStr(x["prefix"]),
sufix = RepUtils.NullToStr(x["sufix"])
}).ToList();
}
return(detil);
}
protected void btnGenReport_Click(object sender, EventArgs e)
{
// проверка параметров отчёта и добавление скрипта генерации отчёта
if (selCnls.Count > 0)
{
DateTime dateFrom;
DateTime dateTo;
int period;
string errMsg;
if (RepUtils.ParseDates(txtDateFrom.Text, txtDateTo.Text, out dateFrom, out dateTo, out errMsg) &&
RepUtils.CheckDayPeriod(dateFrom, dateTo, out period, out errMsg))
{
string cnlNums;
string viewIDs;
ChartUtils.GetSelection(selCnls, out cnlNums, out viewIDs);
ScriptManager.RegisterClientScriptBlock(this, GetType(), "GenerateReportScript",
string.Format("generateReport('{0}', '{1}', {2}, {3}, {4}, {5});",
cnlNums, viewIDs, dateFrom.Year, dateFrom.Month, dateFrom.Day, period), true);
}
else
{
pnlErrMsg.ShowAlert(errMsg);
}
}
}
JsonResult IRole.Get(long id)
{
JsonResult hasil = new JsonResult {
JSONResult = false, JSONMessage = "Data tidak ditemukan", JSONRows = 0, JSONValue = null
};
MRole Obj = new MRole();
using (NpgsqlConnection conn = GetConnection())
{
using (NpgsqlCommand com = new NpgsqlCommand())
{
using (NpgsqlDataAdapter oDA = new NpgsqlDataAdapter())
{
using (DataTable dt = new DataTable())
{
try
{
conn.Open();
com.Connection = conn;
com.CommandTimeout = conn.ConnectionTimeout;
oDA.SelectCommand = com;
com.CommandText = "select mrole.*" +
" from mrole where id=@id";
com.Parameters.Clear();
com.Parameters.AddWithValue("@id", id);
oDA.Fill(dt);
Obj = (from DataRow x in dt.Rows
select new MRole()
{
id = RepUtils.NullToInt(x["id"]),
role = RepUtils.NullToStr(x["role"]),
issupervisor = RepUtils.NullToBool(x["issupervisor"])
}).SingleOrDefault();
hasil = new JsonResult
{
JSONMessage = "Data ditemukan",
JSONResult = true,
JSONRows = (Obj == null ? 0 : 1),
JSONValue = Obj
};
}
catch (Exception ex)
{
hasil = new JsonResult
{
JSONMessage = ex.StackTrace,
JSONResult = false,
JSONRows = 0,
JSONValue = null
};
}
}
}
}
}
return(hasil);
}
public JsonResult GetAvailableUser(string userid)
{
JsonResult hasil = new JsonResult {
JSONResult = true, JSONMessage = "Error unknow resource", JSONRows = 0, JSONValue = null
};
long jmlData = 0;
using (NpgsqlConnection conn = GetConnection())
{
using (NpgsqlCommand com = new NpgsqlCommand())
{
using (NpgsqlDataAdapter oDA = new NpgsqlDataAdapter())
{
try
{
conn.Open();
com.Connection = conn;
com.CommandTimeout = conn.ConnectionTimeout;
com.CommandText = "select count(id) as jmldata from muser where upper(userid) = upper(@userid)";
com.Parameters.Clear();
com.Parameters.Add("@userid", NpgsqlTypes.NpgsqlDbType.Varchar).Value = userid.ToUpper();
jmlData = RepUtils.NullToLong(com.ExecuteScalar());
if (jmlData >= 1)
{
hasil = new JsonResult
{
JSONMessage = "User is not Available",
JSONResult = false,
JSONRows = jmlData,
JSONValue = null
};
}
else
{
hasil = new JsonResult
{
JSONMessage = "User is Available",
JSONResult = true,
JSONRows = 0,
JSONValue = null
};
}
}
catch (Exception ex)
{
hasil = new JsonResult
{
JSONMessage = ex.Message,
JSONResult = false,
JSONRows = 0,
JSONValue = ex
};
}
}
}
}
return(hasil);
}
/// <summary>
/// Установить параметры отчёта.
/// repParams[0] - номера каналов, по которым строится отчёт, int[],
/// repParams[1] - начальная дата данных отчёта, DateTime,
/// repParams[2] - период отображаемых данных, int,
/// repParams[3] - заголовок представления, string
/// </summary>
public override void SetParams(params object[] repParams)
{
cnlNums = (int[])repParams[0];
startDate = (DateTime)repParams[1];
period = (int)repParams[2];
viewTitle = (string)repParams[3];
RepUtils.NormalizeTimeRange(ref startDate, ref period);
}
/// <summary>
/// Конструктор
/// </summary>
public ChartDataBuilder(int[] cnlNums, DateTime startDate, int period, DataAccess dataAccess)
{
dataFormatter = new DataFormatter();
this.dataAccess = dataAccess ?? throw new ArgumentNullException("dataAccess");
this.cnlNums = cnlNums ?? throw new ArgumentNullException("cnlNums");
this.startDate = startDate;
this.period = period;
RepUtils.NormalizeTimeRange(ref this.startDate, ref this.period);
cnlCnt = cnlNums.Length;
cnlPropsArr = new InCnlProps[cnlCnt];
singleTrend = null;
trendBundle = null;
}
protected void Page_Load(object sender, EventArgs e)
{
AppData appData = AppData.GetAppData();
UserData userData = UserData.GetUserData();
// получение ид. представления из параметров запроса
int viewID = Request.QueryString.GetParamAsInt("viewID");
bool eventsByView = viewID > 0;
// проверка входа в систему и прав
if (!userData.LoggedOn)
{
throw new ScadaException(WebPhrases.NotLoggedOn);
}
if (!(userData.UserRights.ViewAllRight ||
eventsByView && userData.UserRights.GetUiObjRights(viewID).ViewRight))
{
throw new ScadaException(CommonPhrases.NoRights);
}
// загрузка представления
BaseView view;
if (eventsByView)
{
Type viewType = userData.UserViews.GetViewType(viewID);
view = appData.ViewCache.GetView(viewType, viewID, true);
}
else
{
view = null;
}
// получение даты запрашиваемых событий
DateTime reqDate = Request.QueryString.GetParamAsDate();
// генерация отчёта
RepBuilder repBuilder = new EventsRepBuilder(appData.DataAccess);
RepUtils.WriteGenerationAction(appData.Log, repBuilder, userData);
RepUtils.GenerateReport(
repBuilder,
new object[] { view, reqDate },
Server.MapPath("~/plugins/Table/templates/"),
RepUtils.BuildFileName("Events", "xml"),
Response);
}
private List <MAkun> getListAkun(List <DataFilters> filters)
{
List <MAkun> obj = new List <MAkun>();
using (NpgsqlConnection conn = GetConnection())
{
using (NpgsqlCommand com = new NpgsqlCommand())
{
using (NpgsqlDataAdapter oDA = new NpgsqlDataAdapter())
{
using (DataTable dt = new DataTable())
{
conn.Open();
com.Connection = conn;
com.CommandTimeout = conn.ConnectionTimeout;
oDA.SelectCommand = com;
com.CommandText = "select makun.*" +
" from makun where 1=1";
RepSqlDatabase.OperatorSQL(com, filters);
oDA.Fill(dt);
obj = (from DataRow x in dt.Rows
select new MAkun()
{
id = RepUtils.NullToLong(x["id"]),
kode = RepUtils.NullToStr(x["kode"]),
nama = RepUtils.NullToStr(x["nama"]),
idparent = RepUtils.NullToLong(x["idparent"]),
iddepartemen = RepUtils.NullToInt(x["iddepartemen"]),
keterangan = RepUtils.NullToStr(x["keterangan"]),
idtype = RepUtils.NullToInt(x["idtype"]),
isdebet = RepUtils.NullToBool(x["isdebet"]),
iskasbank = RepUtils.NullToBool(x["iskasbank"]),
norekening = RepUtils.NullToStr(x["norekening"]),
atasnamarekening = RepUtils.NullToStr(x["atasnamarekening"]),
idtypebank = RepUtils.NullToInt(x["idtypebank"]),
isneraca = RepUtils.NullToBool(x["isneraca"])
}).ToList();
}
}
}
}
return(obj);
}
private List <MKontak> getListKontak(long iduser, List <DataFilters> filters)
{
List <MKontak> obj = new List <MKontak>();
using (NpgsqlConnection conn = GetConnection())
{
using (NpgsqlCommand com = new NpgsqlCommand())
{
using (NpgsqlDataAdapter oDA = new NpgsqlDataAdapter())
{
using (DataTable dt = new DataTable())
{
conn.Open();
com.Connection = conn;
com.CommandTimeout = conn.ConnectionTimeout;
oDA.SelectCommand = com;
com.CommandText = "select mkontak.*" +
" from mkontak inner join mkontakd on mkontakd.idkontak=mkontak.id where mkontakd.iduser=@iduser";
com.Parameters.AddWithValue("@iduser", iduser);
RepSqlDatabase.OperatorSQL(com, filters);
oDA.Fill(dt);
obj = (from DataRow x in dt.Rows
select new MKontak()
{
id = RepUtils.NullToLong(x["id"]),
kode = RepUtils.NullToStr(x["kode"]),
nama = RepUtils.NullToStr(x["nama"]),
alamat1 = RepUtils.NullToStr(x["alamat1"]),
alamat2 = RepUtils.NullToStr(x["alamat2"]),
alamat3 = RepUtils.NullToStr(x["alamat3"]),
hp = RepUtils.NullToStr(x["hp"]),
telpon = RepUtils.NullToStr(x["telpon"]),
iswhatsapp = RepUtils.NullToBool(x["iswhatsapp"]),
norekening = RepUtils.NullToStr(x["norekening"]),
atasnamarekening = RepUtils.NullToStr(x["atasnamarekening"]),
bank = RepUtils.NullToStr(x["bank"])
}).ToList();
}
}
}
}
return(obj);
}
/// <summary>
/// Конструктор
/// </summary>
public ChartDataBuilder(int[] cnlNums, DateTime startDate, int period, int chartGap, DataAccess dataAccess)
{
dataFormatter = new DataFormatter();
this.dataAccess = dataAccess;
this.cnlNums = cnlNums;
this.startDate = startDate;
this.period = period;
this.chartGap = chartGap;
RepUtils.NormalizeTimeRange(ref this.startDate, ref this.period);
cnlCnt = cnlNums.Length;
cnlPropsArr = new InCnlProps[cnlCnt];
cnlNames = new string[cnlCnt];
quantityName = "";
singleTrend = null;
trendBundle = null;
}
protected void Page_Load(object sender, EventArgs e)
{
AppData appData = AppData.GetAppData();
UserData userData = UserData.GetUserData();
// получение ид. представления из параметров запроса
int viewID = Request.QueryString.GetParamAsInt("viewID");
// проверка входа в систему и прав
if (!userData.LoggedOn)
{
throw new ScadaException(WebPhrases.NotLoggedOn);
}
if (!userData.UserRights.GetUiObjRights(viewID).ViewRight)
{
throw new ScadaException(CommonPhrases.NoRights);
}
// загрузка представления
TableView tableView = appData.ViewCache.GetView <TableView>(viewID, true);
// получение оставшихся параметров запроса
DateTime reqDate = Request.QueryString.GetParamAsDate();
int startHour = Request.QueryString.GetParamAsInt("startHour");
int endHour = Request.QueryString.GetParamAsInt("endHour");
// генерация отчёта
RepBuilder repBuilder = new HourDataRepBuilder(appData.DataAccess);
RepUtils.WriteGenerationAction(appData.Log, repBuilder, userData);
RepUtils.GenerateReport(
repBuilder,
new object[] { tableView, reqDate, startHour, endHour },
Server.MapPath("~/plugins/Table/templates/"),
RepUtils.BuildFileName("HourData", "xml"),
Response);
}
private List <MJenisTransaksi> getList(List <DataFilters> filters)
{
List <MJenisTransaksi> obj = new List <MJenisTransaksi>();
using (NpgsqlConnection conn = GetConnection())
{
using (NpgsqlCommand com = new NpgsqlCommand())
{
using (NpgsqlDataAdapter oDA = new NpgsqlDataAdapter())
{
using (DataTable dt = new DataTable())
{
conn.Open();
com.Connection = conn;
com.CommandTimeout = conn.ConnectionTimeout;
oDA.SelectCommand = com;
com.CommandText = "select mjenistransaksi.*" +
" from mjenistransaksi where 1=1";
RepSqlDatabase.OperatorSQL(com, filters);
oDA.Fill(dt);
obj = (from DataRow x in dt.Rows
select new MJenisTransaksi()
{
id = RepUtils.NullToLong(x["id"]),
kode = RepUtils.NullToStr(x["kode"]),
nama = RepUtils.NullToStr(x["nama"]),
nourut = RepUtils.NullToInt(x["nourut"]),
keterangan = RepUtils.NullToStr(x["keterangan"]),
jenistransaksid = getDetil(com, oDA, RepUtils.NullToLong(x["id"]))
}).ToList();
}
}
}
}
return(obj);
}
private List <MUser> getListUser(List <DataFilters> filters)
{
List <MUser> obj = new List <MUser>();
using (NpgsqlConnection conn = GetConnection())
{
using (NpgsqlCommand com = new NpgsqlCommand())
{
using (NpgsqlDataAdapter oDA = new NpgsqlDataAdapter())
{
using (DataTable dt = new DataTable())
{
conn.Open();
com.Connection = conn;
com.CommandTimeout = conn.ConnectionTimeout;
oDA.SelectCommand = com;
com.CommandText = "select muser.*" +
" from muser where 1=1";
RepSqlDatabase.OperatorSQL(com, filters);
oDA.Fill(dt);
obj = (from DataRow x in dt.Rows
select new MUser()
{
id = RepUtils.NullToInt(x["id"]),
userid = RepUtils.NullToStr(x["userid"]),
pwd = "not for publish",
nama = RepUtils.NullToStr(x["nama"]),
idkontak = RepUtils.NullToInt(x["idkontak"]),
idrole = RepUtils.NullToInt(x["idrole"])
}).ToList();
}
}
}
}
return(obj);
}
JsonResult IKontak.Update(long iduser, Models.Dto.MKontak obj)
{
JsonResult hasil = new JsonResult {
JSONResult = false, JSONMessage = "Data tidak ditemukan", JSONRows = 0, JSONValue = null
};
List <MKontak> list = new List <MKontak>();
using (NpgsqlConnection conn = GetConnection())
{
using (NpgsqlCommand com = new NpgsqlCommand())
{
using (NpgsqlDataAdapter oDA = new NpgsqlDataAdapter())
{
try
{
conn.Open();
com.Connection = conn;
com.CommandTimeout = conn.ConnectionTimeout;
com.Transaction = com.Connection.BeginTransaction();
com.CommandText = "delete from mkontakd where idkontak=@id and iduser=@iduser";
com.Parameters.Clear();
com.Parameters.AddWithValue("@id", obj.id);
com.Parameters.AddWithValue("@iduser", iduser);
com.ExecuteNonQuery();
//cek data sudah ada atau belum
com.CommandText = "select id from mkontak where right(hp, LENGTH(hp)-2) = @hp LIMIT 1";
com.Parameters.Clear();
com.Parameters.AddWithValue("@hp", obj.hp);
long jml = RepUtils.NullToLong(com.ExecuteScalar());
if (jml == obj.id)
{
//com.CommandText = "update mkontak set kode=@kode,nama=@nama,alamat1=@alamat1,alamat2=@alamat2,alamat3=@alamat3,hp=@hp,telpon=@telpon,iswhatsapp=@iswhatsapp,norekening=@norekening,bank=@bank,atasnamarekening=@atasnamarekening where id=@id";
//com.Parameters.Clear();
//com.Parameters.Add("@id", NpgsqlTypes.NpgsqlDbType.Bigint).Value = obj.id;
//com.Parameters.Add("@kode", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.kode.Trim();
//com.Parameters.Add("@nama", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.nama.Trim();
//com.Parameters.Add("@alamat1", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.alamat1.Trim();
//com.Parameters.Add("@alamat2", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.alamat2.Trim();
//com.Parameters.Add("@alamat3", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.alamat3.Trim();
//com.Parameters.Add("@hp", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.hp.Trim();
//com.Parameters.Add("@telpon", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.telpon.Trim();
//com.Parameters.Add("@bank", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.bank.Trim();
//com.Parameters.Add("@iswhatsapp", NpgsqlTypes.NpgsqlDbType.Bit).Value = obj.iswhatsapp;
//com.Parameters.Add("@norekening", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.norekening.Trim();
//com.Parameters.Add("@atasnamarekening", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.atasnamarekening.Trim();
//com.ExecuteNonQuery();
}
else
{
if (jml == 0)
{
com.CommandText = "select max(id) from mkontak";
obj.id = RepUtils.NullToLong(com.ExecuteScalar()) + 1;
com.CommandText = "insert into mkontak (id,kode,nama,alamat1,alamat2,alamat3,hp,telpon,iswhatsapp,norekening,bank,atasnamarekening)" +
"values (@id,@kode,@nama,@alamat1,@alamat2,@alamat3,@hp,@telpon,@iswhatsapp,@norekening,@bank,@atasnamarekening)";
com.Parameters.Clear();
com.Parameters.Add("@id", NpgsqlTypes.NpgsqlDbType.Bigint).Value = obj.id;
com.Parameters.Add("@kode", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.kode.Trim();
com.Parameters.Add("@nama", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.nama.Trim();
com.Parameters.Add("@alamat1", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.alamat1.Trim();
com.Parameters.Add("@alamat2", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.alamat2.Trim();
com.Parameters.Add("@alamat3", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.alamat3.Trim();
com.Parameters.Add("@hp", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.hp.Trim();
com.Parameters.Add("@telpon", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.telpon.Trim();
com.Parameters.Add("@bank", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.bank.Trim();
com.Parameters.Add("@iswhatsapp", NpgsqlTypes.NpgsqlDbType.Bit).Value = obj.iswhatsapp;
com.Parameters.Add("@norekening", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.norekening.Trim();
com.Parameters.Add("@atasnamarekening", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.atasnamarekening.Trim();
com.ExecuteNonQuery();
}
else
{
obj.id = jml;
}
}
com.CommandText = "insert into mkontakd (iduser,idkontak,nama,alamat1,alamat2,alamat3,hp,telpon,iswhatsapp,norekening,bank,atasnamarekening)" +
"values (@iduser,@id,@nama,@alamat1,@alamat2,@alamat3,@hp,@telpon,@iswhatsapp,@norekening,@bank,@atasnamarekening)";
com.Parameters.Clear();
com.Parameters.Add("@iduser", NpgsqlTypes.NpgsqlDbType.Bigint).Value = iduser;
com.Parameters.Add("@id", NpgsqlTypes.NpgsqlDbType.Bigint).Value = obj.id;
com.Parameters.Add("@kode", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.kode.Trim();
com.Parameters.Add("@nama", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.nama.Trim();
com.Parameters.Add("@alamat1", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.alamat1.Trim();
com.Parameters.Add("@alamat2", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.alamat2.Trim();
com.Parameters.Add("@alamat3", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.alamat3.Trim();
com.Parameters.Add("@hp", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.hp.Trim();
com.Parameters.Add("@telpon", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.telpon.Trim();
com.Parameters.Add("@bank", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.bank.Trim();
com.Parameters.Add("@iswhatsapp", NpgsqlTypes.NpgsqlDbType.Bit).Value = obj.iswhatsapp;
com.Parameters.Add("@norekening", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.norekening.Trim();
com.Parameters.Add("@atasnamarekening", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.atasnamarekening.Trim();
com.ExecuteNonQuery();
com.Transaction.Commit();
hasil = new JsonResult
{
JSONMessage = "Data tersimpan",
JSONResult = true,
JSONRows = 1,
JSONValue = obj
};
}
catch (Exception ex)
{
hasil = new JsonResult
{
JSONMessage = ex.Message,
JSONResult = false,
JSONRows = 0,
JSONValue = ex
};
}
}
}
}
return(hasil);
}
JsonResult IJenisTransaksi.Get(long id)
{
JsonResult hasil = new JsonResult {
JSONResult = false, JSONMessage = "Data tidak ditemukan", JSONRows = 0, JSONValue = null
};
MJenisTransaksi Obj = new MJenisTransaksi();
using (NpgsqlConnection conn = GetConnection())
{
using (NpgsqlCommand com = new NpgsqlCommand())
{
using (NpgsqlDataAdapter oDA = new NpgsqlDataAdapter())
{
using (DataTable dt = new DataTable())
{
try
{
conn.Open();
com.Connection = conn;
com.CommandTimeout = conn.ConnectionTimeout;
oDA.SelectCommand = com;
com.CommandText = "select mjenistransaksi.*" +
" from mjenistransaksi where id=@id";
com.Parameters.Clear();
com.Parameters.AddWithValue("@id", id);
oDA.Fill(dt);
Obj = (from DataRow x in dt.Rows
select new MJenisTransaksi()
{
id = RepUtils.NullToLong(x["id"]),
kode = RepUtils.NullToStr(x["kode"]),
nama = RepUtils.NullToStr(x["nama"]),
nourut = RepUtils.NullToInt(x["nourut"]),
keterangan = RepUtils.NullToStr(x["keterangan"]),
jenistransaksid = getDetil(com, oDA, RepUtils.NullToLong(x["id"]))
}).SingleOrDefault();
hasil = new JsonResult
{
JSONMessage = "Data ditemukan",
JSONResult = true,
JSONRows = (Obj == null ? 0 : 1),
JSONValue = Obj
};
}
catch (Exception ex)
{
hasil = new JsonResult
{
JSONMessage = ex.StackTrace,
JSONResult = false,
JSONRows = 0,
JSONValue = null
};
}
}
}
}
}
return(hasil);
}
public JsonResult GetLogin(string userid, string pwd)
{
JsonResult hasil = new JsonResult
{
JSONResult = false,
JSONMessage = "Data tidak ditemukan",
JSONRows = 0,
JSONValue = null
};
List <DataFilters> filters = new List <DataFilters>();
filters.Add(new DataFilters
{
FieldName = "upper(userid)",
FieldValue = userid.ToUpper(),
Operator = DataFilters.OperatorQuery.SamaDengan,
Separator = DataFilters.SeparatorQuery.And
});
MUser obj = getDataUser(filters);
if (obj == null)
{
hasil = new JsonResult
{
JSONMessage = "Data tidak ditemukan",
JSONResult = false,
JSONRows = 0,
JSONValue = null
};
}
else
{
//Cek Pwdnya
string PwdMD5Old = "", PwdMD5New = RepUtils.CreateMD5(pwd.ToUpper());
using (Npgsql.NpgsqlConnection con = GetConnection())
{
using (Npgsql.NpgsqlCommand com = new NpgsqlCommand())
{
con.Open();
com.Connection = con;
com.CommandTimeout = con.ConnectionTimeout;
com.CommandText = "select muser.pwd from muser where id=@id";
com.Parameters.Clear();
com.Parameters.AddWithValue("@id", obj.id);
PwdMD5Old = RepUtils.NullToStr(com.ExecuteScalar());
}
}
if (PwdMD5New == PwdMD5Old)
{
hasil = new JsonResult
{
JSONMessage = "Data ditemukan",
JSONResult = true,
JSONRows = 1,
JSONValue = obj
};
}
else
{
hasil = new JsonResult
{
JSONMessage = "Password anda salah",
JSONResult = false,
JSONRows = 0,
JSONValue = null
};
}
}
return(hasil);
}
public JsonResult GetChangePwd(MUser obj, string oldpwd, string newpwd)
{
JsonResult hasil = new JsonResult
{
JSONResult = false,
JSONMessage = "Data tidak ditemukan",
JSONRows = 0,
JSONValue = null
};
List <DataFilters> filters = new List <DataFilters>();
if (obj == null)
{
hasil = new JsonResult
{
JSONMessage = "Data tidak ditemukan",
JSONResult = false,
JSONRows = 0,
JSONValue = null
};
}
else if (oldpwd == null || oldpwd == "")
{
hasil = new JsonResult
{
JSONMessage = "Password lama anda salah",
JSONResult = false,
JSONRows = 0,
JSONValue = null
};
}
else if (newpwd == null || newpwd == "" || newpwd.Length < 8)
{
hasil = new JsonResult
{
JSONMessage = "Password harus diisi minimum 8 digit",
JSONResult = false,
JSONRows = 0,
JSONValue = null
};
}
else
{
//Cek Pwdnya
string PwdMD5Old = RepUtils.CreateMD5(oldpwd.ToUpper()), PwdMD5New = RepUtils.CreateMD5(newpwd.ToUpper());
using (Npgsql.NpgsqlConnection con = GetConnection())
{
using (Npgsql.NpgsqlCommand com = new NpgsqlCommand())
{
con.Open();
com.Connection = con;
com.CommandTimeout = con.ConnectionTimeout;
com.CommandText = "select muser.pwd from muser where id=@id";
com.Parameters.Clear();
com.Parameters.AddWithValue("@id", obj.id);
if (PwdMD5Old == RepUtils.NullToStr(com.ExecuteScalar()))
{
com.CommandText = "update muser set pwd=@pwd where id=@id";
com.Parameters.Clear();
com.Parameters.AddWithValue("@id", obj.id);
com.Parameters.AddWithValue("@pwd", PwdMD5New);
com.ExecuteNonQuery();
hasil = new JsonResult
{
JSONMessage = "Data berhasil diubah",
JSONResult = true,
JSONRows = 1,
JSONValue = obj
};
}
else
{
hasil = new JsonResult
{
JSONMessage = "Password lama anda salah",
JSONResult = false,
JSONRows = 0,
JSONValue = null
};
}
}
}
}
return(hasil);
}
JsonResult IBase <MUser> .Save(Models.Dto.MUser obj)
{
JsonResult hasil = new JsonResult {
JSONResult = false, JSONMessage = "Data tidak ditemukan", JSONRows = 0, JSONValue = null
};
List <MUser> list = new List <MUser>();
using (NpgsqlConnection conn = GetConnection())
{
using (NpgsqlCommand com = new NpgsqlCommand())
{
using (NpgsqlDataAdapter oDA = new NpgsqlDataAdapter())
{
try
{
conn.Open();
com.Connection = conn;
com.CommandTimeout = conn.ConnectionTimeout;
com.Transaction = com.Connection.BeginTransaction();
com.CommandText = "insert into muser (id,userid,pwd,nama,idkontak,idrole)" +
"values (@id,@userid,@pwd,@nama,@idkontak,@idrole)";
com.Parameters.Clear();
com.Parameters.Add("@id", NpgsqlTypes.NpgsqlDbType.Bigint).Value = obj.id;
com.Parameters.Add("@userid", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.userid.ToUpper().Trim();
com.Parameters.Add("@pwd", NpgsqlTypes.NpgsqlDbType.Varchar).Value = RepUtils.CreateMD5(obj.pwd.ToUpper().Trim());
com.Parameters.Add("@nama", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.nama.Trim();
com.Parameters.Add("@idkontak", NpgsqlTypes.NpgsqlDbType.Integer).Value = obj.idkontak;
com.Parameters.Add("@idrole", NpgsqlTypes.NpgsqlDbType.Integer).Value = obj.idrole;
com.ExecuteNonQuery();
//cek data sudah ada atau belum
com.CommandText = "select id from mkontak where right(upper(hp), LENGTH(upper(hp))-2) = @hp LIMIT 1";
com.Parameters.Clear();
com.Parameters.AddWithValue("@hp", obj.userid.ToUpper());
long jml = RepUtils.NullToLong(com.ExecuteScalar());
if (jml == 0)
{
com.CommandText = "select max(id) from mkontak";
jml = RepUtils.NullToLong(com.ExecuteScalar()) + 1;
com.CommandText = "insert into mkontak (id,kode,nama,alamat1,alamat2,alamat3,hp,telpon,iswhatsapp,norekening,bank,atasnamarekening)" +
"values (@id,@kode,@nama,@alamat1,@alamat2,@alamat3,@hp,@telpon,@iswhatsapp,@norekening,@bank,@atasnamarekening)";
com.Parameters.Clear();
com.Parameters.Add("@id", NpgsqlTypes.NpgsqlDbType.Bigint).Value = jml;
com.Parameters.Add("@kode", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.userid.ToUpper().Trim();
com.Parameters.Add("@nama", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.nama.Trim();
com.Parameters.Add("@alamat1", NpgsqlTypes.NpgsqlDbType.Varchar).Value = "";
com.Parameters.Add("@alamat2", NpgsqlTypes.NpgsqlDbType.Varchar).Value = "";
com.Parameters.Add("@alamat3", NpgsqlTypes.NpgsqlDbType.Varchar).Value = "";
com.Parameters.Add("@hp", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.userid.ToUpper();
com.Parameters.Add("@telpon", NpgsqlTypes.NpgsqlDbType.Varchar).Value = "";
com.Parameters.Add("@bank", NpgsqlTypes.NpgsqlDbType.Varchar).Value = "";
com.Parameters.Add("@iswhatsapp", NpgsqlTypes.NpgsqlDbType.Bit).Value = false;
com.Parameters.Add("@norekening", NpgsqlTypes.NpgsqlDbType.Varchar).Value = "";
com.Parameters.Add("@atasnamarekening", NpgsqlTypes.NpgsqlDbType.Varchar).Value = "";
com.ExecuteNonQuery();
}
obj.idkontak = jml;
com.CommandText = "update muser set idkontak=@idkontak where id=@id";
com.Parameters.Clear();
com.Parameters.AddWithValue("@idkontak", obj.idkontak);
com.Parameters.AddWithValue("@id", obj.id);
com.ExecuteNonQuery();
com.Transaction.Commit();
hasil = new JsonResult
{
JSONMessage = "Data tersimpan",
JSONResult = true,
JSONRows = 1,
JSONValue = obj
};
}
catch (Exception ex)
{
hasil = new JsonResult
{
JSONMessage = ex.Message,
JSONResult = false,
JSONRows = 0,
JSONValue = ex
};
}
}
}
}
return(hasil);
}
