public void Create(Document_Model model)
{
var data = Connect_Enttity.Documents.FirstOrDefault(x => x.Id == model.Id);
if (data == null)
{
var entity = new Document();
entity.Code = model.Code;
entity.Name = model.Name;
entity.Images = model.Images;
entity.CreateDate = Convert.ToDateTime(model.CreateDate);
entity.EffectiveDate = Convert.ToDateTime(model.EffectiveDate);
entity.Info = model.Info;
entity.File = model.File;
entity.Ord = (int)(model.Ord);
entity.Priority = (int)(model.Priority);
entity.Active = (int)(model.Active);
entity.TypeId = (int)(model.TypeId);
entity.MemberId = (int)(model.MemberId);
entity.Lang = model.Lang;
entity.NameEn = model.NameEn;
entity.infoEn = model.infoEn;
Connect_Enttity.Documents.Add(entity);
Connect_Enttity.SaveChanges();
Dispose();
}
}
public IList <Document_Model> GetId(Document_Model model)
{
IList <Document_Model> result = new List <Document_Model>();
result = Connect_Enttity.Documents.Where(x => x.Id == model.Id).Select(x => new Document_Model
{
Id = x.Id,
Code = x.Code,
Name = x.Name,
Images = x.Images,
CreateDate = Convert.ToDateTime(x.CreateDate),
EffectiveDate = Convert.ToDateTime(x.EffectiveDate),
Info = x.Info,
File = x.File,
Ord = (int)(x.Ord),
Priority = (int)(x.Priority),
Active = (int)(x.Active),
TypeId = (int)(x.TypeId),
MemberId = (int)(x.MemberId),
Lang = x.Lang,
NameEn = x.NameEn,
infoEn = x.infoEn
}).ToList();
return(result);
}
public void Update(Document_Model model)
{
var data = Connect_Enttity.Documents.FirstOrDefault(x => x.Id == model.Id);
if (data != null)
{
data.Code = model.Code;
data.Name = model.Name;
data.Images = model.Images;
data.CreateDate = Convert.ToDateTime(model.CreateDate);
data.EffectiveDate = Convert.ToDateTime(model.EffectiveDate);
data.Info = model.Info;
data.File = model.File;
data.Ord = (int)(model.Ord);
data.Priority = (int)(model.Priority);
data.Active = (int)(model.Active);
data.TypeId = (int)(model.TypeId);
data.MemberId = (int)(model.MemberId);
data.Lang = model.Lang;
data.NameEn = model.NameEn;
data.infoEn = model.infoEn;
Connect_Enttity.SaveChanges();
Dispose();
}
}
public int Save_Update_Delete_Document(string fileName, Document_Model _doc)
{
int id = 0;
try
{
cmd = new SqlCommand("Document", cmd.Connection);
cmd.Connection = DbConnect.CreateConnection(6);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@DocumentId", _doc.DocumentId);
cmd.Parameters.AddWithValue("@DocumentPath", fileName);
//cmd.Parameters.AddWithValue("@CreatedBy", _doc.CreatedBy);
cmd.Parameters.AddWithValue("@CreatedBy", SessionInfo.CreatedBy);
cmd.Parameters.AddWithValue("@Action", _doc.Action);
cmd.Connection.Open();
id = Convert.ToInt32(cmd.ExecuteScalar());
cmd.Connection.Close();
return(id);
}
catch (Exception ex)
{
return(id);
}
}
public Document_Bal(Document_Dal _obj, Document_Model _objdoc)
{
obj = _obj;
_doc = _objdoc;
}
public IEnumerable <Document_Model> ReadID(Document_Model model)
{
return(GetId(model));
}
