public bool Create(TB_PhotoExt model, ref string Msg, Controller ctrl)
{
bool status = true;
TB_Photo obj = new TB_Photo();
// MailTable.MailTemplateID =model.MailTemplateID;
// obj.ID = model.ID;
obj.PartID = model.PartID;
obj.RecordID = model.RecordID;
obj.Name = model.Name;
obj.MainPhoto = model.MainPhoto;
obj.Sort = Convert.ToInt32(model.Sorts);
obj.Active = model.Active;
obj.CreateDateTime = DateTime.Now;
obj.CreateUserID = Convert.ToInt64(ctrl.Session["UserID"]);
obj.OpDateTime = DateTime.Now;
obj.OpUserID = Convert.ToInt64(ctrl.Session["UserID"]);
db.TB_Photo.Add(obj);
db.SaveChanges();
Int64 id = obj.ID;
return status;
}
public bool Delete(TB_PhotoExt model, ref string Msg, Controller ctrl)
{
bool status = true;
var obj = db.TB_Photo.Where(x => x.ID == model.ID).FirstOrDefault();
db.TB_Photo.Remove(obj);
db.SaveChanges();
return status;
}
public bool Update(TB_PhotoExt model, ref string Msg, Controller ctrl)
{
bool status = true;
var obj = db.TB_Photo.Where(x => x.ID == model.ID).FirstOrDefault();
// MailTable.MailTemplateID =model.MailTemplateID;
obj.ID = model.ID;
obj.PartID = model.PartID;
obj.RecordID = model.RecordID;
obj.Name = model.Name;
obj.MainPhoto = model.MainPhoto;
obj.Sort = Convert.ToInt32(model.Sorts);
obj.Active = model.Active;
obj.OpDateTime = DateTime.Now;
obj.OpUserID = Convert.ToInt64(ctrl.Session["UserID"]);
db.SaveChanges();
return status;
}
public List<TB_PhotoExt> ReadAll(int TableID)
{
List<TB_PhotoExt> list = new List<TB_PhotoExt>();
DataTable dt = new DataTable();
SQLCon.Open();
SqlCommand cmd = new SqlCommand("B_DisplayTable_BizTbl_Table_Sp", SQLCon);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@TableID", TableID);
cmd.Parameters.AddWithValue("@CultureCode", CultureCode);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(dt);
SQLCon.Close();
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
TB_PhotoExt model = new TB_PhotoExt();
model.ID = Convert.ToInt64(dr["ID"]);
model.PartName = dr["FK_PartID_ID"].ToString();
model.PartID = Convert.ToInt32(dr["PartID"]);
model.RecordID = Convert.ToInt64(dr["RecordID"].ToString());
model.Name = dr["Name"].ToString();
try
{
model.MainPhoto = Convert.ToBoolean(dr["MainPhoto"].ToString());
}
catch
{
model.MainPhoto = false;
}
model.Sorts = dr["Sort"].ToString();
model.Active = Convert.ToBoolean(dr["Active"].ToString());
model.Operation = dr["Operation"].ToString();
list.Add(model);
}
}
return list;
}
