public RefModel Get(string refType)
{
var refs = new RefModel();
try
{
using (OggleBoobleMySqContext db = new OggleBoobleMySqContext())
{
IList <Ref> dbrefs = db.Refs.Where(r => r.RefType == refType).OrderBy(r => r.RefDescription).ToList();
foreach (Ref r in dbrefs)
{
refs.refItems.Add(new RefItem()
{
RefCode = r.RefCode,
RefType = r.RefType,
RefDescription = r.RefDescription
});
}
refs.Success = "ok";
}
}
catch (Exception ex)
{
refs.Success = Helpers.ErrorDetails(ex);
}
return(refs);
}
}// end of function
public RefModel GetLastNO(RefModel _refmodel, string _checkType, string _Brstn)
{
DBConnect();
string sql = "SELECT * FROM captive_database.isla_ref where BRSTN ='" + _Brstn + "' and CheckType ='" + _checkType + "'";
MySqlCommand cmd = new MySqlCommand(sql, myConnect);
MySqlDataReader myReader = cmd.ExecuteReader();
while (myReader.Read())
{
_refmodel.ID = int.Parse(myReader.GetString(0));
_refmodel.Date = DateTime.Parse(myReader.GetString(1));
_refmodel.BRSTN = myReader.GetString(2);
_refmodel.CheckType = myReader.GetString(3);
_refmodel.LastNo = myReader.GetInt64(4);
_refmodel.BranchName = myReader.GetString(5);
_refmodel.P_Before = int.Parse(myReader.GetString(6));
_refmodel.C_Before = int.Parse(myReader.GetString(7));
}
DBClosed();
return(_refmodel);
}// end of function
}// end of function
public RefModel UpdateRef(RefModel _ref)
{
DBConnect();
string sql = "Update captive_database.isla_ref SET LastNo = '" + _ref.LastNo + "', Date = '" + _ref.Date.ToString("yyyy-MM-dd") + "' where BRSTN = '" + _ref.BRSTN + "' and CheckType = '" + _ref.CheckType + "'";
MySqlCommand cmd = new MySqlCommand(sql, myConnect);
MySqlDataReader myReader = cmd.ExecuteReader();
DBClosed();
return(_ref);
}// end of function
public ActionResult SefRef(RefModel model)
{
var ass = Assembly.LoadFile(Server.MapPath("~/bin/MyProject.EntityFramework.dll"));
var type = ass.GetType("MyProject.EntityFramework.Models." + model.TableName);
foreach (var item in model.Props)
{
var p = type.GetProperty(item.Key, BindingFlags.IgnoreCase | BindingFlags.Public | BindingFlags.Instance);
if (p == null)
{
continue;
}
var @ref = new T_Ref()
{
TableName = model.TableName,
FiledName = p.Name,
LanguageID = model.LanguageId,
RowID = model.Id,
RowValue = item.Value
};
var file = Request.Files["props.file_" + item.Key];
if (file != null && file.ContentLength > 0)
{
@ref.RowValue = SaveFile(file);
}
var refModel = dbContent.Refs.FirstOrDefault(x =>
x.TableName == @ref.TableName &&
x.FiledName == @ref.FiledName &&
x.LanguageID == @ref.LanguageID &&
x.RowID == @ref.RowID);
if (refModel != null)
{
refModel.RowValue = @ref.RowValue;
}
else
{
dbContent.Refs.Add(@ref);
}
}
dbContent.SaveChanges();
return(Ok());
}
