public ActionResult AdminRegServices(tblServices collection)
{
try
{
//Registrar datos
SqlParameter param1 = new SqlParameter("@name", collection.servName);
var db = new DBPawnshopEntitiesConection();
var data = db.Database.ExecuteSqlCommand("setServName @name", param1);
TempData["Prueba"] = "SI";
@ViewData["ID"] = TempData["Prueba"];
return(View());
}
catch (Exception e)
{
return(View(e.Message));
}
}
public ActionResult AdminEditServices2(tblServices collection)
{
try
{
//Edición del servicio
string idServicios = System.Web.HttpContext.Current.Session["idServ"].ToString();
var db = new DBPawnshopEntitiesConection();
SqlParameter param1 = new SqlParameter("@id", idServicios);
SqlParameter param2 = new SqlParameter("@name", collection.servName);
var data = db.Database.ExecuteSqlCommand("updateServData @id, @name", param1, param2);
TempData["Prueba"] = "SI";
@ViewData["ID"] = TempData["Prueba"];
return(View());
}
catch (Exception e)
{
return(View(e.Message));
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
string dateInsert = DateTime.Now.ToString("yyyy/MM/dd");
string timeInsert = DateTime.Now.ToString("hh:mm:ss");
tblServicesCollection detReadTbl = new tblServicesCollection();
tblServices detTbl = new tblServices();
tblServicePic detPicTbl = new tblServicePic();
if (txtTitle.Text.Trim().Length > 0)
{
detTbl.ServiceTitle = txtTitle.Text;
if (ckDetails.Text.Trim().Length > 0)
{
string str = ckDetails.Text;
detTbl.ServiceDetail = Server.HtmlDecode(str);
}
else
{
detTbl.ServiceDetail = "";
}
detTbl.idAgeGroup = 1;
detTbl.Gender = 0;
detTbl.idServiceGroup = Int32.Parse(ddlNewsGroup.SelectedValue);
detTbl.Create();
detReadTbl.ReadList();
// file upload start
string filename = string.Empty;
Boolean fileOK = false;
String path = Server.MapPath("~/images/service/");
// if picture
detPicTbl.idService = detReadTbl[detReadTbl.Count - 1].id;
if (IsPostBack)
{
if (fuGallery.HasFile)
{
String fileExtension = System.IO.Path.GetExtension(fuGallery.FileName).ToLower();
String[] allowedExtensions = { ".jpg", ".png", ".bmp", ".gif" };
for (int i = 0; i < allowedExtensions.Length; i++)
{
if (fileExtension == allowedExtensions[i])
{
fileOK = true;
}
}
}
if (fileOK)
{
try
{
fuGallery.PostedFile.SaveAs(path + fuGallery.FileName);
filename = fuGallery.FileName;
}
catch (Exception ex)
{
lblError.Text = "A problem with uplouding picture";
}
}
else
{
lblError.Text = "Not valid picture";
}
}
//file upload end
if (filename.Trim().Length > 0)
{
detPicTbl.picName = filename;
}
else
{
detPicTbl.picName = "default.jpg";
}
detPicTbl.picAddr = "~/images/service/";
detPicTbl.picDetails = "";
detPicTbl.allow = "1";
detPicTbl.Create();
Response.Redirect("services-add.aspx");
}
else
{
lblError.Text = "* please enter title frist.";
}
}
