public ActionResult Create(POCO.CompanyInfo ocompany)
{
try
{
HttpPostedFileBase file = Request.Files["UploadImage"];
var bs = new byte[file.ContentLength];
using (var fs = file.InputStream)
{
var offset = 0;
do
{
offset += fs.Read(bs, offset, bs.Length - offset);
} while (offset < bs.Length);
}
ocompany.Img = bs;
///
ocompanyInfoDBL.D_CompanyInfo_Insert(ocompany);
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
ex.ToString();
return(View());
}
}
//Edit (Get)
public POCO.CompanyInfo D_CompanyInfoGetToUpdate(decimal ID)
{
ds = new DataSet();
oCompany = new POCO.CompanyInfo();
ds = ocompanyInfoDAL.D_CompanyInfoGetToUpdate(ID);
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
oCompany.ID = Convert.ToInt32(ds.Tables[0].Rows[0]["id"]);
oCompany.CompanyID = Convert.ToInt32(ds.Tables[0].Rows[0]["CompanyID"]);
oCompany.CompanyNameAr = ds.Tables[0].Rows[0]["CompanyNameAr"].ToString();
oCompany.CompanyNameEn = ds.Tables[0].Rows[0]["CompanyNameEn"].ToString();
oCompany.Address = ds.Tables[0].Rows[0]["Address"].ToString();
oCompany.Fax = ds.Tables[0].Rows[0]["Fax"].ToString();
oCompany.Phone = ds.Tables[0].Rows[0]["Phone"].ToString();
oCompany.FooterLine1 = ds.Tables[0].Rows[0]["FooterLine1"].ToString();
oCompany.FooterLine2 = ds.Tables[0].Rows[0]["FooterLine2"].ToString();
oCompany.Img = (byte[])ds.Tables[0].Rows[0]["Img"];
}
}
return(oCompany);
}
public POCO.CompanyInfo D_CompanyInfo_Insert(POCO.CompanyInfo PoCompany)
{
DataSet ds = new DataSet();
oCompany = new POCO.CompanyInfo();
ds = ocompanyInfoDAL.D_CompanyInfo_Insert(PoCompany.CompanyID, PoCompany.CompanyNameAr, PoCompany.Phone, PoCompany.CompanyNameEn, PoCompany.Address, PoCompany.Fax, PoCompany.FooterLine1, PoCompany.FooterLine2, PoCompany.Img);
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
oCompany.ID = Convert.ToInt32(ds.Tables[0].Rows[0]["id"]);
oCompany.CompanyID = Convert.ToInt32(ds.Tables[0].Rows[0]["CompanyID"]);
oCompany.CompanyNameAr = ds.Tables[0].Rows[0]["CompanyNameAr"].ToString();
oCompany.CompanyNameEn = ds.Tables[0].Rows[0]["CompanyNameEn"].ToString();
oCompany.Address = ds.Tables[0].Rows[0]["Address"].ToString();
oCompany.Fax = ds.Tables[0].Rows[0]["Fax"].ToString();
oCompany.Phone = ds.Tables[0].Rows[0]["Phone"].ToString();
oCompany.FooterLine1 = ds.Tables[0].Rows[0]["FooterLine1"].ToString();
oCompany.FooterLine2 = ds.Tables[0].Rows[0]["FooterLine2"].ToString();
oCompany.Img = (byte[])ds.Tables[0].Rows[0]["Img"];
}
}
return(oCompany);
}
public List <POCO.CompanyInfo> D_CompanyInfo_Get()
{
DataSet ds = new DataSet();
List <POCO.CompanyInfo> ocompanyList = new List <POCO.CompanyInfo>();
ds = ocompanyInfoDAL.D_CompanyInfo_Get();
foreach (DataTable table in ds.Tables)
{
foreach (DataRow dr in table.Rows)
{
oCompany = new POCO.CompanyInfo();
oCompany.ID = Convert.ToInt32(dr["id"]);
oCompany.CompanyID = Convert.ToInt32(dr["CompanyID"]);
oCompany.CompanyNameAr = dr["CompanyNameAr"].ToString();
oCompany.CompanyNameEn = dr["CompanyNameEn"].ToString();
oCompany.Address = dr["Address"].ToString();
oCompany.Fax = dr["Fax"].ToString();
oCompany.Phone = dr["Phone"].ToString();
oCompany.FooterLine1 = dr["FooterLine1"].ToString();
oCompany.FooterLine2 = dr["FooterLine2"].ToString();
oCompany.Img = (byte[])dr["Img"];
ocompanyList.Add(oCompany);
}
}
return(ocompanyList);
}
// GET: CompanyInfo/Edit/5
public ActionResult Edit(decimal id)
{
ocompany = new POCO.CompanyInfo();
ocompany = ocompanyInfoDBL.D_CompanyInfoGetToUpdate(id);
return(View(ocompany));
}
// Edit(Post)
public void D_CompanyInfo_Update(POCO.CompanyInfo PoCompany)
{
ocompanyInfoDAL.D_CompanyInfo_Update(PoCompany.ID, PoCompany.CompanyID, PoCompany.CompanyNameAr, PoCompany.Phone, PoCompany.CompanyNameEn, PoCompany.Address, PoCompany.Fax, PoCompany.FooterLine1, PoCompany.FooterLine2, PoCompany.Img);
}
