Пример #1
0
        public ActionResult Create(AdPostViewModel viewModel)
        {
            if (!ModelState.IsValid)
            {
                return(View("Create", viewModel));
            }
            var ad = new AdPostModel
            {
                ClientName  = viewModel.ClientName,
                Address     = viewModel.Address,
                Date        = DateTime.Today,
                Description = viewModel.Description,
                Price       = viewModel.Price,
                Email       = viewModel.Email
            };

            _context.Ads.Add(ad);
            _context.SaveChanges();

            return(RedirectToAction("Index", "Home"));
        }
Пример #2
0
        public DataTable get(AdPostModel a)
        {
            SqlConnection conn = new SqlConnection(commonCode.conStr);

            conn.Open();
            SqlCommand cmd = new SqlCommand("Pro_AdCRUD", conn);

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@ad_Id", SqlDbType.Int).Value            = a.ad_Id;
            cmd.Parameters.Add("@login_Id", SqlDbType.Int).Value         = a.login_Id;
            cmd.Parameters.Add("@category_Id", SqlDbType.Int).Value      = a.category_Id;
            cmd.Parameters.Add("@subCategory_Id", SqlDbType.Int).Value   = a.subCategory_Id;
            cmd.Parameters.Add("@lastDate", SqlDbType.DateTime).Value    = a.lastDate == Convert.ToDateTime("1/1/0001 12:00:00 AM") ? DateTime.Now : a.lastDate;
            cmd.Parameters.Add("@dataCount", SqlDbType.Int).Value        = a.dataCount;
            cmd.Parameters.Add("@location_id", SqlDbType.NVarChar).Value = a.location_id;
            cmd.Parameters.Add("@mode", SqlDbType.NVarChar).Value        = a.mode;
            DataSet        ds = new DataSet();
            SqlDataAdapter da = new SqlDataAdapter();

            da.SelectCommand = cmd;
            da.Fill(ds);
            DataTable Dt = ds.Tables[0];

            conn.Close();
            if (Dt.Rows.Count > 0)
            {
                List <AdPostModel> fm = new List <AdPostModel>();
                fm = commonCode.ConvertDataTable <AdPostModel>(Dt);
                for (int i = 0; i < fm.Count; i++)
                {
                    fm[i].favlogins = listfav(fm[i].ad_Id);
                }
                Dt = ToDataTable(fm);
            }
            return(Dt);
        }
Пример #3
0
        public int delete(AdPostModel a)
        {
            try
            {
                SqlConnection con = new SqlConnection(commonCode.conStr);
                con.Open();
                SqlCommand cmd = new SqlCommand("Pro_AdCRUD", con);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add("@ad_Id", SqlDbType.Int).Value     = a.ad_Id;
                cmd.Parameters.Add("@mode", SqlDbType.NVarChar).Value = a.mode;

                int s = (int)cmd.ExecuteNonQuery();
                con.Close();
                if (s < 0)
                {
                    s = -1;
                }
                return(s);
            }
            catch (Exception ex)
            {
                return(-1);
            }
        }
Пример #4
0
        public CommonModal Insert(AdPostModel a)
        {
            CommonModal   e1   = new CommonModal();
            SqlConnection conn = new SqlConnection(commonCode.conStr);

            conn.Open();
            SqlCommand cmd = new SqlCommand("Pro_AdCRUD", conn);

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@ad_Id", SqlDbType.Int).Value                  = a.ad_Id;
            cmd.Parameters.Add("@login_Id", SqlDbType.Int).Value               = a.login_Id;
            cmd.Parameters.Add("@name", SqlDbType.NVarChar).Value              = a.name;
            cmd.Parameters.Add("@price", SqlDbType.Int).Value                  = a.price;
            cmd.Parameters.Add("@description", SqlDbType.NVarChar).Value       = a.description;
            cmd.Parameters.Add("@category_Id", SqlDbType.Int).Value            = a.category_Id;
            cmd.Parameters.Add("@subCategory_Id", SqlDbType.Int).Value         = a.subCategory_Id;
            cmd.Parameters.Add("@companyName", SqlDbType.NVarChar).Value       = a.companyName;
            cmd.Parameters.Add("@contactPerson", SqlDbType.NVarChar).Value     = a.contactPerson;
            cmd.Parameters.Add("@mobileNo", SqlDbType.NVarChar).Value          = a.mobileNo;
            cmd.Parameters.Add("@landlineNo", SqlDbType.NVarChar).Value        = a.landlineNo;
            cmd.Parameters.Add("@Parking", SqlDbType.NVarChar).Value           = a.Parking;
            cmd.Parameters.Add("@Features", SqlDbType.NVarChar).Value          = a.Features;
            cmd.Parameters.Add("@SuperBuildUparea", SqlDbType.NVarChar).Value  = a.SuperBuildUparea;
            cmd.Parameters.Add("@PlotArea", SqlDbType.NVarChar).Value          = a.PlotArea;
            cmd.Parameters.Add("@CallibrateDate", SqlDbType.NVarChar).Value    = a.CallibrateDate;
            cmd.Parameters.Add("@CallibrateMachine", SqlDbType.NVarChar).Value = a.CallibrateMachine;
            cmd.Parameters.Add("@GSTNumber", SqlDbType.NVarChar).Value         = a.GSTNumber;
            cmd.Parameters.Add("@PlantCapacity", SqlDbType.NVarChar).Value     = a.PlantCapacity;
            cmd.Parameters.Add("@companyAddress", SqlDbType.NVarChar).Value    = a.companyAddress;
            cmd.Parameters.Add("@plantCompany", SqlDbType.NVarChar).Value      = a.plantCompany;
            cmd.Parameters.Add("@modelYear", SqlDbType.NVarChar).Value         = a.modelYear;
            cmd.Parameters.Add("@serialNo", SqlDbType.NVarChar).Value          = a.serialNo;
            cmd.Parameters.Add("@newCost", SqlDbType.Int).Value                = a.newCost;
            cmd.Parameters.Add("@expectCost", SqlDbType.Int).Value             = a.expectCost;
            cmd.Parameters.Add("@location", SqlDbType.NVarChar).Value          = a.location;
            cmd.Parameters.Add("@location_id", SqlDbType.NVarChar).Value       = a.location_id;
            cmd.Parameters.Add("@comment", SqlDbType.NVarChar).Value           = a.comment;
            cmd.Parameters.Add("@image1", SqlDbType.NVarChar).Value            = a.image1;
            cmd.Parameters.Add("@payment_status", SqlDbType.Int).Value         = a.payment_status;
            cmd.Parameters.Add("@category", SqlDbType.NVarChar).Value          = a.category;
            cmd.Parameters.Add("@no_labours", SqlDbType.Int).Value             = a.no_labours;
            cmd.Parameters.Add("@available", SqlDbType.NVarChar).Value         = a.available;
            cmd.Parameters.Add("@mode", SqlDbType.NVarChar).Value              = a.mode;
            DataSet        ds = new DataSet();
            SqlDataAdapter da = new SqlDataAdapter();

            da.SelectCommand = cmd;
            da.Fill(ds);
            DataTable Dt  = ds.Tables[0];
            DataTable Dt1 = ds.Tables[1];

            conn.Close();
            if (Dt.Rows.Count > 0)
            {
                e1.ResponseStatus  = Dt1.Rows[0]["status"].ToString();
                e1.ResponseMessage = Dt1.Rows[0]["MSG"].ToString();
                e1.data            = Dt;
            }
            else
            {
                e1.ResponseStatus  = "False";
                e1.ResponseMessage = "Ad Posting Failed";
            }
            return(e1);
        }
Пример #5
0
        public DataTable search(AdPostModel a)
        {
            SqlConnection conn = new SqlConnection(commonCode.conStr);

            conn.Open();
            SqlCommand cmd = new SqlCommand("Pro_searchalltables", conn);

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@location_id", SqlDbType.NVarChar).Value = a.location_id;
            cmd.Parameters.Add("@category_Id", SqlDbType.Int).Value      = a.category_Id;
            cmd.Parameters.Add("@mode", SqlDbType.NVarChar).Value        = a.mode;
            DataSet        ds = new DataSet();
            SqlDataAdapter da = new SqlDataAdapter();

            da.SelectCommand = cmd;
            da.Fill(ds);
            DataTable Dt = ds.Tables[0];

            conn.Close();
            if (Dt.Rows.Count > 0)
            {
                if (a.category_Id == 26)
                {
                    List <AdJobModel> fm = new List <AdJobModel>();
                    fm = commonCode.ConvertDataTable <AdJobModel>(Dt);
                    for (int i = 0; i < fm.Count; i++)
                    {
                        fm[i].favlogins = listfavjob(fm[i].Job_Id);
                    }
                    Dt = ToDataTable(fm);
                }

                else if (a.category_Id == 7)
                {
                    Dt.Columns.Add("favlogins", typeof(System.Int32[]));

                    foreach (DataRow row in Dt.Rows)
                    {
                        row["favlogins"] = new int[0];
                    }
                }
                else
                {
                    List <AdPostModel> fm = new List <AdPostModel>();
                    fm = commonCode.ConvertDataTable <AdPostModel>(Dt);
                    for (int i = 0; i < fm.Count; i++)
                    {
                        fm[i].favlogins = listfav(fm[i].ad_Id);
                    }
                    Dt = ToDataTable(fm);
                }
            }



            //if (Dt.Rows.Count > 0)
            //{
            //    Dt.Columns.Add("favlogins", typeof(System.Int32[]));

            //    foreach (DataRow n in Dt.Rows)
            //    {
            //        if (Convert.ToInt32(n["category_Id"]) == 26)
            //        {
            //            n["favlogins"] = listfavjob(Convert.ToInt32(n["Job_Id"]));
            //        }

            //        else if (Convert.ToInt32(n["category_Id"]) != 7)
            //        {
            //            n["favlogins"] = "";
            //        }
            //        else
            //        {
            //            n["favlogins"] = listfav(Convert.ToInt32(n["ad_Id"]));
            //        }

            //    }
            //}
            return(Dt);
        }