Example #1
0
        public bool SaveCollege(SaveCollegeDTO obj)
        {
            bool res = false;

            obj.CreatedBy = "1001";
            SqlCommand cmd = new SqlCommand("sp_SaveCollege");

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@p_Name", obj.Name);
            cmd.Parameters.AddWithValue("@p_Address", obj.Address);
            cmd.Parameters.AddWithValue("@p_University", obj.University);
            cmd.Parameters.AddWithValue("@p_City", obj.City);
            cmd.Parameters.AddWithValue("@p_State", obj.State);
            cmd.Parameters.AddWithValue("@p_Country", obj.Country);
            cmd.Parameters.AddWithValue("@p_Logo", obj.Logo);
            cmd.Parameters.AddWithValue("@p_CompanyWebsite", obj.CompanyWebSite);
            cmd.Parameters.AddWithValue("@p_ContactNumber", obj.ContactNumber);
            cmd.Parameters.AddWithValue("@p_Email", obj.Email);
            cmd.Parameters.AddWithValue("@p_ActionBy", obj.CreatedBy);
            int result = new DBlayer().ExecuteNonQuery(cmd);

            if (result != Int32.MaxValue)
            {
                res = true;
            }
            return(res);
        }
Example #2
0
        public HttpResponseMessage SaveCollege()
        {
            HttpResponseMessage message;


            var httpRequest = HttpContext.Current.Request.Files[0];
            var Logo        = httpRequest.FileName;


            // var httpRequest = HttpContext.Current.Request.Files;
            var Name       = HttpContext.Current.Request.Form[0];
            var Address    = HttpContext.Current.Request.Form[1];
            var University = HttpContext.Current.Request.Form[2];
            var City       = HttpContext.Current.Request.Form[3];
            var State      = HttpContext.Current.Request.Form[4];
            var Country    = HttpContext.Current.Request.Form[5];
            // var Logo = HttpContext.Current.Request.Form[6];
            var CompanyWebSite = HttpContext.Current.Request.Form[6];
            var ContactNumber  = HttpContext.Current.Request.Form[7];
            var Email          = HttpContext.Current.Request.Form[8];
            //  var CreatedBy = HttpContext.Current.Request.Form[9];

            SaveCollegeDTO save = new SaveCollegeDTO();

            save.Logo           = Logo;
            save.Name           = Name;
            save.Address        = Address;
            save.University     = Convert.ToInt32(University);
            save.City           = Convert.ToInt32(City);
            save.State          = Convert.ToInt32(State);
            save.Country        = Convert.ToInt32(Country);
            save.CompanyWebSite = CompanyWebSite;
            save.ContactNumber  = ContactNumber;
            save.Email          = Email;
            // save.CreatedBy = CreatedBy;

            if (httpRequest != null && Logo != null)
            {
                var pathf        = HttpContext.Current.Server.MapPath("~/UploadFile");
                var fileSavePath = Path.Combine(pathf, Logo);

                Directory.CreateDirectory(pathf);
                httpRequest.SaveAs(fileSavePath);
            }


            try
            {
                CollegeDAL dal    = new CollegeDAL();
                var        dynobj = new { result = dal.SaveCollege(save) };
                message = Request.CreateResponse(HttpStatusCode.OK, dynobj);
            }
            catch (Exception ex)
            {
                message = Request.CreateResponse(HttpStatusCode.BadRequest, new { msgText = "Somthing wrong, Try Again!" });
            }

            return(message);
        }