Ejemplo n.º 1
0
        public async Task <WmsdsResponse <int> > AddChannel(Channel channel)
        {
            var wmsdResponse = new WmsdsResponse <int>();

            if (channel == null)
            {
                wmsdResponse.ResponseCode    = EnumStatus.EmptyObject;
                wmsdResponse.ResponseMessage = "Object is empty.";
                return(wmsdResponse);
            }

            if (channel.DistrictId <= 0 || string.IsNullOrEmpty(channel.DistrictName))
            {
                wmsdResponse.ResponseCode    = EnumStatus.ValidationFailed;;
                wmsdResponse.ResponseMessage = "DistrictId is a required field.";
                return(wmsdResponse);
            }

            if (channel.TehsilId <= 0)
            {
                wmsdResponse.ResponseCode    = EnumStatus.ValidationFailed;;
                wmsdResponse.ResponseMessage = "TehsilId is a required field.";
                return(wmsdResponse);
            }

            if (string.IsNullOrEmpty(channel.ChannelName))
            {
                wmsdResponse.ResponseCode    = EnumStatus.ValidationFailed;;
                wmsdResponse.ResponseMessage = "Channel Name is a required field.";
                return(wmsdResponse);
            }

            try
            {
                using (var _dbContext = new EntityContext())
                {
                    _dbContext.Channels.Add(channel);
                    var response = await _dbContext.SaveChangesAsync();

                    if (response > 0)
                    {
                        wmsdResponse.ResponseCode    = EnumStatus.Success;;
                        wmsdResponse.ResponseMessage = "Channel has been added successfully.";
                        return(wmsdResponse);
                    }
                    else
                    {
                        wmsdResponse.ResponseCode    = EnumStatus.Failed;;
                        wmsdResponse.ResponseMessage = "Failed to add channel.";
                        return(wmsdResponse);
                    }
                }
            }
            catch (Exception ex)
            {
                wmsdResponse.ResponseCode    = EnumStatus.InternalServer;
                wmsdResponse.ResponseMessage = ex.Message;
                return(wmsdResponse);
            }
        }
Ejemplo n.º 2
0
        public async Task <WmsdsResponse <DistrictWiseWcImprDto> > GetDistrictWiseWcImprStatus()
        {
            var wmsdResponse = new WmsdsResponse <DistrictWiseWcImprDto>();

            wmsdResponse.DataObject = new DistrictWiseWcImprDto();
            try
            {
                using (var dbContext = new EntityContext())
                {
                    var distWiseData = await(from wc in dbContext.WcIdentifications
                                             from wd in dbContext.WcIdentificationDetails
                                             where wc.Id == wd.WcIdentificationId
                                             group wd by new { wc.DistrictName, wd.ImprovementType } into g
                                             select new DistrictWiseWcImprDto
                    {
                        District        = g.Key.DistrictName,
                        ImprovementType = g.Key.ImprovementType,
                        Value           = g.Count(x => x.WcIdentificationId != 0)
                    }).ToListAsync();
                    wmsdResponse.ResponseCode = EnumStatus.Success;
                    wmsdResponse.Collections  = distWiseData;
                    return(wmsdResponse);
                }
            }
            catch (Exception ex)
            {
                wmsdResponse.ResponseCode    = EnumStatus.Error;
                wmsdResponse.ResponseMessage = ex.Message;
                return(wmsdResponse);
            }
        }
Ejemplo n.º 3
0
        public async Task <WmsdsResponse <LengthOfWcDto> > GetLengthOfImprovedWc()
        {
            var wmsdResponse = new WmsdsResponse <LengthOfWcDto>();

            wmsdResponse.DataObject = new LengthOfWcDto();
            try
            {
                using (var dbContext = new EntityContext())
                {
                    var earthenTotalLen = await dbContext.WcIdentificationDetails.SumAsync(x => x.EarthenLengthM);

                    var linedTotalLen = await dbContext.WcIdentificationDetails.SumAsync(x => x.LiningLengthM);

                    wmsdResponse.ResponseCode       = EnumStatus.Success;
                    wmsdResponse.DataObject.Earthen = (int)earthenTotalLen / 1000;//KM
                    //wmsdResponse.DataObject.Earthen = wmsdResponse.DataObject.Earthen / 1000;//"000KM"

                    wmsdResponse.DataObject.Lined = (int)linedTotalLen / 1000;//KM
                    //wmsdResponse.DataObject.Lined = wmsdResponse.DataObject.Lined / 1000;//"000KM"

                    wmsdResponse.DataObject.TotalLength = wmsdResponse.DataObject.Earthen + wmsdResponse.DataObject.Lined;
                    return(wmsdResponse);
                }
            }
            catch (Exception ex)
            {
                wmsdResponse.ResponseCode    = EnumStatus.Error;
                wmsdResponse.ResponseMessage = ex.Message;
                return(wmsdResponse);
            }
        }
Ejemplo n.º 4
0
        public async Task <WmsdsResponse <KeyValueDto> > GetWcImprovementStatus()
        {
            var wmsdResponse = new WmsdsResponse <KeyValueDto>();

            wmsdResponse.DataObject = new KeyValueDto();
            try
            {
                using (var dbContext = new EntityContext())
                {
                    var wcImprovementStatus = await(from wd in dbContext.WcIdentificationDetails
                                                    group wd by new { wd.ImprovementType } into g
                                                    select new KeyValueDto
                    {
                        name = g.Key.ImprovementType,
                        y    = g.Count(x => x.WcIdentificationId != 0)
                    }).ToListAsync();

                    wmsdResponse.ResponseCode = EnumStatus.Success;
                    wmsdResponse.Collections  = wcImprovementStatus;
                    return(wmsdResponse);
                }
            }
            catch (Exception ex)
            {
                wmsdResponse.ResponseCode    = EnumStatus.Error;
                wmsdResponse.ResponseMessage = ex.Message;
                return(wmsdResponse);
            }
        }
Ejemplo n.º 5
0
        public async Task <JsonResult> GetWcListing(WcIdentification model)
        {
            IWaterCourseService waterCourseService             = new WaterCourseService();
            WmsdsResponse <WcIdentification> WcIdentifications = await waterCourseService.GetWcIdentifications(1, model.DistrictId, model.TehsilId, model.ChannelId, 0, null);

            return(Json(WcIdentifications.Collections, JsonRequestBehavior.AllowGet));
        }
Ejemplo n.º 6
0
        public async Task <WmsdsResponse <HeisIdentification> > GetHeisIdentifications(int currentPageIndex = 1, int districtId = 0, int tehsilId = 0, string byName = null, string byCnic = null)
        {
            var heisIdentificationOut = new WmsdsResponse <HeisIdentification>();

            using (var _dbContext = new EntityContext())
            {
                int maxRows = 20;
                heisIdentificationOut.Collections = await _dbContext.HeisIdentifications
                                                    .Where(c => districtId == 0 || c.DistrictId == districtId)
                                                    .Where(c => tehsilId == 0 || c.TehsilId == tehsilId)
                                                    .Where(c => byCnic == null || c.FarmerCNIC.Contains(byCnic))
                                                    .Where(c => byName == null || c.FarmerName.Contains(byName))
                                                    .Include(x => x.HeisIdentificationDetails)
                                                    .OrderBy(x => x.Id)
                                                    .Skip((currentPageIndex - 1) * maxRows)
                                                    .Take(maxRows).ToListAsync();

                int rowCount = await _dbContext.HeisIdentifications
                               .Where(c => districtId == 0 || c.DistrictId == districtId)
                               .Where(c => tehsilId == 0 || c.TehsilId == tehsilId)
                               .Where(c => byCnic == null || c.FarmerCNIC.Contains(byCnic))
                               .Where(c => byName == null || c.FarmerName.Contains(byName))
                               .CountAsync();


                heisIdentificationOut.TotalRecords = rowCount;
                double pageCount = (double)((decimal)rowCount / Convert.ToDecimal(maxRows));
                heisIdentificationOut.PageCount        = (int)Math.Ceiling(pageCount);
                heisIdentificationOut.CurrentPageIndex = currentPageIndex;
                return(heisIdentificationOut);
            }
        }
Ejemplo n.º 7
0
        public async Task <WmsdsResponse <WatercoureseStatusDto> > GetStatusOfWatercourses()
        {
            var wmsdResponse = new WmsdsResponse <WatercoureseStatusDto>();

            wmsdResponse.DataObject = new WatercoureseStatusDto();
            try
            {
                using (var dbContext = new EntityContext())
                {
                    var improvedWcCount = await(from wc in dbContext.WcIdentifications
                                                from wd in dbContext.WcIdentificationDetails
                                                where wc.Id == wd.WcIdentificationId
                                                select wc.Id).CountAsync();

                    var totalWcCourse = await dbContext.WaterCourses.CountAsync();


                    wmsdResponse.DataObject.TotalWaterCourse      = totalWcCourse;
                    wmsdResponse.DataObject.ImprovedWaterCourse   = improvedWcCount;
                    wmsdResponse.DataObject.UnImprovedWaterCourse = totalWcCourse - improvedWcCount;
                    wmsdResponse.ResponseCode    = EnumStatus.Success;
                    wmsdResponse.ResponseMessage = "Success";
                    return(wmsdResponse);
                }
            }
            catch (Exception ex)
            {
                wmsdResponse.ResponseCode    = EnumStatus.Error;
                wmsdResponse.ResponseMessage = ex.Message;
                return(wmsdResponse);
            }
        }
Ejemplo n.º 8
0
        public async Task <WmsdsResponse <ImplicationFinancialDto> > GetImplicationFinancial()
        {
            var wmsdResponse = new WmsdsResponse <ImplicationFinancialDto>();

            wmsdResponse.DataObject = new ImplicationFinancialDto();
            try
            {
                using (var dbContext = new EntityContext())
                {
                    //TODO: discuss about farmer share
                    var totalGovtShare = await dbContext.WcIdentificationDetails.SumAsync(x => x.TotalCostOfCivilWrkVerfied);//Govt

                    var linedTotalLen = await dbContext.WcIdentificationDetails.SumAsync(x => x.LiningLengthM);

                    wmsdResponse.ResponseCode = EnumStatus.Success;
                    //wmsdResponse.DataObject.GovtAssistance = (int)earthenTotalLen / 1000;//KM
                    //wmsdResponse.DataObject.Earthen = wmsdResponse.DataObject.Earthen / 1000;//"000KM"

                    //wmsdResponse.DataObject.Lined = (int)linedTotalLen / 1000;//KM
                    //wmsdResponse.DataObject.Lined = wmsdResponse.DataObject.Lined / 1000;//"000KM"

                    //wmsdResponse.DataObject.TotalLength = wmsdResponse.DataObject.Earthen + wmsdResponse.DataObject.Lined;
                    return(wmsdResponse);
                }
            }
            catch (Exception ex)
            {
                wmsdResponse.ResponseCode    = EnumStatus.Error;
                wmsdResponse.ResponseMessage = ex.Message;
                return(wmsdResponse);
            }
        }
Ejemplo n.º 9
0
        public async Task <WmsdsResponse <int> > AddHeisIdentification(HeisIdentification heisIdentification)
        {
            var wmsdResponse = new WmsdsResponse <int>();

            if (heisIdentification == null)
            {
                wmsdResponse.ResponseCode    = EnumStatus.EmptyObject;
                wmsdResponse.ResponseMessage = "Object is empty.";
                return(wmsdResponse);
            }

            if (heisIdentification.DistrictId <= 0 || string.IsNullOrEmpty(heisIdentification.DistrictName))
            {
                wmsdResponse.ResponseCode    = EnumStatus.ValidationFailed;;
                wmsdResponse.ResponseMessage = "DistrictId is a required field.";
                return(wmsdResponse);
            }

            if (heisIdentification.TehsilId <= 0 || string.IsNullOrEmpty(heisIdentification.TehsilName))
            {
                wmsdResponse.ResponseCode    = EnumStatus.ValidationFailed;;
                wmsdResponse.ResponseMessage = "TehsilId is a required field.";
                return(wmsdResponse);
            }
            if (await IsHeisIdentificationAlreadyExist(heisIdentification))
            {
                wmsdResponse.ResponseCode    = EnumStatus.AlreadyExist;
                wmsdResponse.ResponseMessage = "Watercourse already exists.";
                return(wmsdResponse);
            }
            //Check if status is Addation than there must be a regular water course
            try
            {
                using (var _dbContext = new EntityContext())
                {
                    _dbContext.HeisIdentifications.Add(heisIdentification);
                    var response = await _dbContext.SaveChangesAsync();

                    if (response > 0)
                    {
                        wmsdResponse.ResponseCode    = EnumStatus.Success;;
                        wmsdResponse.ResponseMessage = "Identicification has been added successfully.";
                        return(wmsdResponse);
                    }
                    else
                    {
                        wmsdResponse.ResponseCode    = EnumStatus.Failed;;
                        wmsdResponse.ResponseMessage = "Failed to add channel.";
                        return(wmsdResponse);
                    }
                }
            }
            catch (Exception ex)
            {
                wmsdResponse.ResponseCode    = EnumStatus.InternalServer;
                wmsdResponse.ResponseMessage = ex.Message;
                return(wmsdResponse);
            }
        }
Ejemplo n.º 10
0
        /// <summary>
        /// Get List of Identifications
        /// </summary>
        /// <param name="districtId"></param>
        /// <param name="tehsilId"></param>
        /// <param name="channelId"></param>
        /// <param name="improveYearId"></param>
        /// <returns></returns>
        public async Task <WmsdsResponse <WcIdentification> > GetWcIdentifications(int currentPageIndex = 1, int districtId = 0, int tehsilId = 0, int channelId = 0, int improveYearId = 0, string improvementType = null)
        {
            var wcIdentificationOut = new WmsdsResponse <WcIdentification>();

            using (var _dbContext = new EntityContext())
            {
                try
                {
                    //var wcIdentifications = await (from ep in _dbContext.WcIdentifications
                    //                        join d in _dbContext.WcIdentificationDetails on ep.Id equals d.WcIdentificationId
                    //                        where
                    //                        (ep.DistrictId == 0 || ep.DistrictId == districtId) && (ep.TehsilId == 0 || ep.TehsilId == tehsilId)
                    //                        && (d.ImprovementYearId == 0 || d.ImprovementYearId == tehsilId)
                    //                        && (d.ImprovementType == null || d.ImprovementType == improvementType)

                    //                               select new WcIdentification
                    //                        {
                    //                            Id = ep.Id,
                    //                            DivisionName = ep.DivisionName,
                    //                            DistrictName = ep.DistrictName,
                    //                            TehsilName = ep.TehsilName

                    //                        }).ToListAsync();

                    int maxRows = 20;

                    wcIdentificationOut.Collections = await _dbContext.WcIdentifications
                                                      .Where(c => districtId == 0 || c.DistrictId == districtId)
                                                      .Where(c => tehsilId == 0 || c.TehsilId == tehsilId)
                                                      .Where(c => channelId == 0 || c.ChannelId == channelId)
                                                      .Include(x => x.WcIdentificationDetails)
                                                      .OrderBy(x => x.Id)
                                                      .Skip((currentPageIndex - 1) * maxRows)
                                                      .Take(maxRows).ToListAsync();

                    int rowCount = await _dbContext.WcIdentifications
                                   .Where(c => districtId == 0 || c.DistrictId == districtId)
                                   .Where(c => tehsilId == 0 || c.TehsilId == tehsilId)
                                   .Where(c => channelId == 0 || c.ChannelId == channelId).CountAsync();

                    wcIdentificationOut.TotalRecords = rowCount;
                    double pageCount = (double)((decimal)rowCount / Convert.ToDecimal(maxRows));
                    wcIdentificationOut.PageCount        = (int)Math.Ceiling(pageCount);
                    wcIdentificationOut.CurrentPageIndex = currentPageIndex;
                    return(wcIdentificationOut);
                }
                catch (Exception ex)
                {
                    return(null);
                }

                //.Where(c => improveYearId == 0 || c.ImprovementYearId == improveYearId)
            }
        }
Ejemplo n.º 11
0
        public async Task <WmsdsResponse <HeisIdentificationDetail> > AddHeisBasicInformation(HeisIdentificationDetail heisIdentificationDetail)
        {
            var wmsdResponse = new WmsdsResponse <HeisIdentificationDetail>();

            if (heisIdentificationDetail == null)
            {
                wmsdResponse.ResponseCode    = EnumStatus.EmptyObject;
                wmsdResponse.ResponseMessage = "Object is empty.";
                return(wmsdResponse);
            }

            if (heisIdentificationDetail.HeisIdentificationId <= 0)
            {
                wmsdResponse.ResponseCode    = EnumStatus.EmptyObject;
                wmsdResponse.ResponseMessage = "HEIS Parent Identification key is empty.";
                return(wmsdResponse);
            }

            try
            {
                using (var _dbContext = new EntityContext())
                {
                    _dbContext.HeisIdentificationDetails.Add(heisIdentificationDetail);
                    var response = await _dbContext.SaveChangesAsync();

                    if (response > 0)
                    {
                        wmsdResponse.ResponseCode    = EnumStatus.Success;
                        wmsdResponse.DataObject      = new HeisIdentificationDetail();
                        wmsdResponse.DataObject.Id   = heisIdentificationDetail.Id;
                        wmsdResponse.ResponseMessage = "Record has been added successfully.";
                        return(wmsdResponse);
                    }
                    else
                    {
                        wmsdResponse.ResponseCode    = EnumStatus.Failed;;
                        wmsdResponse.ResponseMessage = "Failed to update record.";
                        return(wmsdResponse);
                    }
                }
            }
            catch (Exception ex)
            {
                wmsdResponse.ResponseCode    = EnumStatus.InternalServer;
                wmsdResponse.ResponseMessage = ex.Message;
                return(wmsdResponse);
            }
        }
Ejemplo n.º 12
0
        public async Task <WmsdsResponse <WcIdentificationDetail> > GetIdentificationDetailByMasterId(int wcIdentificationId)
        {
            var wmsdResponse = new WmsdsResponse <WcIdentificationDetail>();

            if (wcIdentificationId <= 0)
            {
                wmsdResponse.ResponseCode    = EnumStatus.RequiredField;
                wmsdResponse.ResponseMessage = "Water Course Id is missing.";
                return(wmsdResponse);
            }

            using (var _dbContext = new EntityContext())
            {
                try
                {
                    var wcIdentification = await _dbContext.WcIdentificationDetails
                                           .Where(c => c.WcIdentificationId == wcIdentificationId)
                                           .FirstOrDefaultAsync();

                    if (wcIdentification != null)
                    {
                        wmsdResponse.ResponseCode    = EnumStatus.Success;
                        wmsdResponse.DataObject      = wcIdentification;
                        wmsdResponse.ResponseMessage = "Record Found.";
                        return(wmsdResponse);
                    }
                    else
                    {
                        wmsdResponse.ResponseCode    = EnumStatus.NotFound;
                        wmsdResponse.ResponseMessage = "No Record Found.";
                        return(wmsdResponse);
                    }
                }
                catch (Exception ex)
                {
                    wmsdResponse.ResponseCode    = EnumStatus.InternalServer;
                    wmsdResponse.ResponseMessage = ex.Message;
                    return(wmsdResponse);
                }
            }
        }
Ejemplo n.º 13
0
        public async Task <WmsdsResponse <HeisIdentification> > GetHeisIdentificationById(int heisIdentificationId)
        {
            var wmsdResponse = new WmsdsResponse <HeisIdentification>();

            if (heisIdentificationId <= 0)
            {
                wmsdResponse.ResponseCode    = EnumStatus.RequiredField;
                wmsdResponse.ResponseMessage = "HEIS Identification Id is missing.";
                return(wmsdResponse);
            }

            using (var _dbContext = new EntityContext())
            {
                try
                {
                    var wcIdentification = await _dbContext.HeisIdentifications
                                           .Where(c => c.Id == heisIdentificationId)
                                           .SingleOrDefaultAsync();

                    if (wcIdentification != null)
                    {
                        wmsdResponse.ResponseCode    = EnumStatus.Success;
                        wmsdResponse.DataObject      = wcIdentification;
                        wmsdResponse.ResponseMessage = "Record Found.";
                        return(wmsdResponse);
                    }
                    else
                    {
                        wmsdResponse.ResponseCode    = EnumStatus.NotFound;
                        wmsdResponse.ResponseMessage = "No Record Found.";
                        return(wmsdResponse);
                    }
                }
                catch (Exception ex)
                {
                    wmsdResponse.ResponseCode    = EnumStatus.InternalServer;
                    wmsdResponse.ResponseMessage = ex.Message;
                    return(wmsdResponse);
                }
            }
        }
Ejemplo n.º 14
0
        public async Task <ActionResult> AddUpdateHEISDetails(FormCollection formCollection)
        {
            try
            {
                int HeisIdentificationId       = Convert.ToInt16(formCollection["hdHeisIdentificationIdBI"]);
                int HeisIdentificationDetailId = Convert.ToInt16(formCollection["hdHeisIdentificationDetailsIdBI"]);

                double   Latitude                 = Convert.ToDouble(formCollection["txtLatitude"]);
                double   Longitude                = Convert.ToDouble(formCollection["txtLongitude"]);
                string   InstallationType         = formCollection["ddlInstallationType"] + "".Replace("--Select--", "");
                string   FiscalYear               = formCollection["ddlFiscalYear"] + "".Replace("--Select--", "");
                string   SystemType               = formCollection["ddlSystemType"] + "".Replace("--Select--", "");
                string   SSCName                  = formCollection["ddlSSCName"] + "".Replace("--Select--", "");
                string   ProjectName              = formCollection["ddlProjectName"] + "".Replace("--Select--", "");
                string   VillageName              = formCollection["txtVillageName"];
                string   ContactNumber            = formCollection["txtContactNumber"];
                int      SchemeArea               = Convert.ToInt16(formCollection["txtSchemeArea"]);
                string   WaterSource              = formCollection["ddlWaterSource"] + "".Replace("--Select--", "");
                string   WaterQuality             = formCollection["ddlWaterQuality"] + "".Replace("--Select--", "");
                string   PowerSource              = formCollection["ddlPowerSource"] + "".Replace("--Select--", "");
                string   CropCategory             = formCollection["ddlCropCategory"] + "".Replace("--Select--", "");
                string   CropName                 = formCollection["ddlCropName"] + "".Replace("--Select--", "");
                int      PlansPerAcre             = Convert.ToInt16(formCollection["txtPlansPerAcre"]);
                string   SystemClassification     = formCollection["ddlSystemClassification"] + "".Replace("--Select--", "");
                string   WorkOrderIssued          = formCollection["ddlWorkOrderIssued"] + "".Replace("--Select--", "");
                DateTime DesignApprovalDate       = DateTime.ParseExact(formCollection["txtDesignApprovalDate"].ToString(), "dd/MM/yyyy", CultureInfo.InvariantCulture);
                int      TotalApprovedProjectCost = Convert.ToInt16(formCollection["txtTotalApprovedProjectCost"]);
                int      TotalDynamicHead         = Convert.ToInt16(formCollection["txtTotalDynamicHead"]);
                string   PumpType                 = formCollection["ddlPumpType"] + "".Replace("--Select--", "");
                int      PumpFlowRate             = Convert.ToInt16(formCollection["txtPumpFlowRate"]);
                int      PowerSourceEfficiency    = Convert.ToInt16(formCollection["txtPowerSourceEfficiency"]);

                HeisIdentificationDetail heisIdentificationDetail = new HeisIdentificationDetail();
                heisIdentificationDetail.HeisIdentificationId = HeisIdentificationId;
                heisIdentificationDetail.Id = HeisIdentificationDetailId;

                heisIdentificationDetail.Latitude                 = Latitude;
                heisIdentificationDetail.Longitude                = Longitude;
                heisIdentificationDetail.InstallationType         = InstallationType;
                heisIdentificationDetail.FiscalYear               = FiscalYear;
                heisIdentificationDetail.SystemType               = SystemType;
                heisIdentificationDetail.SSCName                  = SSCName;
                heisIdentificationDetail.ProjectName              = ProjectName;
                heisIdentificationDetail.VillageName              = VillageName;
                heisIdentificationDetail.ContactNumber            = ContactNumber;
                heisIdentificationDetail.SchemeArea               = SchemeArea;
                heisIdentificationDetail.WaterSource              = WaterSource;
                heisIdentificationDetail.WaterQuality             = WaterQuality;
                heisIdentificationDetail.PowerSource              = PowerSource;
                heisIdentificationDetail.CropCategory             = CropCategory;
                heisIdentificationDetail.CropName                 = CropName;
                heisIdentificationDetail.PlansPerAcre             = PlansPerAcre;
                heisIdentificationDetail.SystemClassification     = SystemClassification;
                heisIdentificationDetail.WorkOrderIssued          = WorkOrderIssued;
                heisIdentificationDetail.DesignApprovalDate       = DesignApprovalDate;
                heisIdentificationDetail.TotalApprovedProjectCost = TotalApprovedProjectCost;
                heisIdentificationDetail.TotalDynamicHead         = TotalDynamicHead;
                heisIdentificationDetail.PumpType                 = PumpType;
                heisIdentificationDetail.PumpFlowRate             = PumpFlowRate;
                heisIdentificationDetail.PowerSourceEfficiency    = PowerSourceEfficiency;


                IHeisService heisCourseService = new HeisService();
                var          response          = new WmsdsResponse <HeisIdentificationDetail>();
                var          responseUpdate    = new WmsdsResponse <int>();
                if (HeisIdentificationDetailId == 0)
                {
                    response = await heisCourseService.AddHeisBasicInformation(heisIdentificationDetail);

                    return(Json(response, JsonRequestBehavior.AllowGet));
                }
                else
                {
                    responseUpdate = await heisCourseService.UpdateHeisBasicInformation(heisIdentificationDetail);

                    return(Json(responseUpdate, JsonRequestBehavior.AllowGet));
                }
            }
            catch (Exception ex)
            {
                return(Json(new { FormId = 0, HttpStatusCode = HttpStatusCode.NotImplemented }));
            }
        }
Ejemplo n.º 15
0
        public async Task <WmsdsResponse <int> > UpdateHeisBasicInformation(HeisIdentificationDetail heisIdentificationDetail)
        {
            var wmsdResponse = new WmsdsResponse <int>();

            if (heisIdentificationDetail == null)
            {
                wmsdResponse.ResponseCode    = EnumStatus.EmptyObject;
                wmsdResponse.ResponseMessage = "Object is empty.";
                return(wmsdResponse);
            }

            if (heisIdentificationDetail.HeisIdentificationId <= 0)
            {
                wmsdResponse.ResponseCode    = EnumStatus.EmptyObject;
                wmsdResponse.ResponseMessage = "Parent Identification key is empty.";
                return(wmsdResponse);
            }
            if (heisIdentificationDetail.Id <= 0)
            {
                wmsdResponse.ResponseCode    = EnumStatus.EmptyObject;
                wmsdResponse.ResponseMessage = "Id is missing.";
                return(wmsdResponse);
            }

            try
            {
                using (var _dbContext = new EntityContext())
                {
                    var basicInfoDb = await _dbContext.HeisIdentificationDetails
                                      .Where(c => c.Id == heisIdentificationDetail.Id &&
                                             c.HeisIdentificationId == heisIdentificationDetail.HeisIdentificationId)
                                      .SingleOrDefaultAsync();

                    if (basicInfoDb != null)
                    {
                        basicInfoDb.InstallationType = string.IsNullOrEmpty(heisIdentificationDetail.InstallationType)
                            ? basicInfoDb.InstallationType : heisIdentificationDetail.InstallationType;

                        basicInfoDb.FiscalYear = string.IsNullOrEmpty(heisIdentificationDetail.FiscalYear)
                            ? basicInfoDb.FiscalYear : heisIdentificationDetail.FiscalYear;

                        basicInfoDb.FiscalYearId = heisIdentificationDetail.FiscalYearId <= 0
                            ? basicInfoDb.FiscalYearId : heisIdentificationDetail.FiscalYearId;

                        basicInfoDb.SystemType = string.IsNullOrEmpty(heisIdentificationDetail.SystemType)
                             ? basicInfoDb.SystemType : heisIdentificationDetail.SystemType;


                        basicInfoDb.SSCName = string.IsNullOrEmpty(heisIdentificationDetail.SSCName)
                            ? basicInfoDb.SSCName : heisIdentificationDetail.SSCName;
                        basicInfoDb.SSCId = heisIdentificationDetail.SSCId <= 0
                           ? basicInfoDb.SSCId : heisIdentificationDetail.SSCId;

                        basicInfoDb.ProjectName = string.IsNullOrEmpty(heisIdentificationDetail.ProjectName)
                            ? basicInfoDb.ProjectName : heisIdentificationDetail.ProjectName;
                        basicInfoDb.VillageName = string.IsNullOrEmpty(heisIdentificationDetail.VillageName)
                            ? basicInfoDb.VillageName : heisIdentificationDetail.VillageName;
                        basicInfoDb.ContactNumber = string.IsNullOrEmpty(heisIdentificationDetail.ContactNumber)
                            ? basicInfoDb.ContactNumber : heisIdentificationDetail.ContactNumber;

                        basicInfoDb.SoilType = string.IsNullOrEmpty(heisIdentificationDetail.SoilType)
                            ? basicInfoDb.SoilType : heisIdentificationDetail.SoilType;
                        basicInfoDb.SchemeArea = heisIdentificationDetail.SchemeArea <= 0
                          ? basicInfoDb.SchemeArea : heisIdentificationDetail.SchemeArea;
                        basicInfoDb.WaterSource = string.IsNullOrEmpty(heisIdentificationDetail.WaterSource)
                            ? basicInfoDb.WaterSource : heisIdentificationDetail.WaterSource;
                        basicInfoDb.WaterQuality = string.IsNullOrEmpty(heisIdentificationDetail.WaterQuality)
                            ? basicInfoDb.WaterQuality : heisIdentificationDetail.WaterQuality;

                        basicInfoDb.PowerSource = string.IsNullOrEmpty(heisIdentificationDetail.PowerSource)
                            ? basicInfoDb.PowerSource : heisIdentificationDetail.PowerSource;
                        basicInfoDb.CropCategory = string.IsNullOrEmpty(heisIdentificationDetail.CropCategory)
                            ? basicInfoDb.CropCategory : heisIdentificationDetail.CropCategory;
                        basicInfoDb.CropName = string.IsNullOrEmpty(heisIdentificationDetail.CropName)
                            ? basicInfoDb.CropName : heisIdentificationDetail.CropName;
                        basicInfoDb.PlansPerAcre = heisIdentificationDetail.PlansPerAcre <= 0
                         ? basicInfoDb.PlansPerAcre : heisIdentificationDetail.PlansPerAcre;
                        basicInfoDb.SystemClassification = string.IsNullOrEmpty(heisIdentificationDetail.SystemClassification)
                            ? basicInfoDb.SystemClassification : heisIdentificationDetail.SystemClassification;
                        basicInfoDb.Latitude = heisIdentificationDetail.Latitude <= 0
                                ? basicInfoDb.Latitude : heisIdentificationDetail.Latitude;
                        basicInfoDb.Longitude = heisIdentificationDetail.Longitude <= 0
                                ? basicInfoDb.Longitude : heisIdentificationDetail.Longitude;

                        var response = await _dbContext.SaveChangesAsync();

                        if (response > 0)
                        {
                            wmsdResponse.ResponseCode    = EnumStatus.Success;;
                            wmsdResponse.ResponseMessage = "Record has been added successfully.";
                            return(wmsdResponse);
                        }
                        else
                        {
                            wmsdResponse.ResponseCode    = EnumStatus.Failed;;
                            wmsdResponse.ResponseMessage = "Failed to update record.";
                            return(wmsdResponse);
                        }
                    }
                    else
                    {
                        wmsdResponse.ResponseCode    = EnumStatus.NotFound;;
                        wmsdResponse.ResponseMessage = "No Record found against given Ids.";
                        return(wmsdResponse);
                    }
                }
            }
            catch (Exception ex)
            {
                wmsdResponse.ResponseCode    = EnumStatus.InternalServer;
                wmsdResponse.ResponseMessage = ex.Message;
                return(wmsdResponse);
            }
        }
Ejemplo n.º 16
0
        /// <summary>
        /// AddWorksExecuted will add/update below sections
        /// i-Design Parameters
        /// ii-Work Order
        /// iii-Material Verification (ICR-I)
        /// iv-Commissioning Verification (ICR-II)
        /// v-Third Installment (ICR-III)
        /// </summary>
        /// <param name="heisIdentificationDetail"></param>
        /// <returns></returns>
        public async Task <WmsdsResponse <int> > AddWorksExecuted(HeisIdentificationDetail heisIdentificationDetail)
        {
            var wmsdResponse = new WmsdsResponse <int>();

            if (heisIdentificationDetail == null)
            {
                wmsdResponse.ResponseCode    = EnumStatus.EmptyObject;
                wmsdResponse.ResponseMessage = "Object is empty.";
                return(wmsdResponse);
            }

            if (heisIdentificationDetail.HeisIdentificationId <= 0)
            {
                wmsdResponse.ResponseCode    = EnumStatus.EmptyObject;
                wmsdResponse.ResponseMessage = "Parent Identification key is empty.";
                return(wmsdResponse);
            }
            if (heisIdentificationDetail.Id <= 0)
            {
                wmsdResponse.ResponseCode    = EnumStatus.EmptyObject;
                wmsdResponse.ResponseMessage = "Id is missing.";
                return(wmsdResponse);
            }

            try
            {
                using (var _dbContext = new EntityContext())
                {
                    var basicInfoDb = await _dbContext.HeisIdentificationDetails
                                      .Where(c => c.Id == heisIdentificationDetail.Id &&
                                             c.HeisIdentificationId == heisIdentificationDetail.HeisIdentificationId)
                                      .SingleOrDefaultAsync();

                    if (basicInfoDb != null)
                    {
                        #region Design Parameters

                        basicInfoDb.DesignApproved = string.IsNullOrEmpty(heisIdentificationDetail.DesignApproved)
                            ? basicInfoDb.DesignApproved : heisIdentificationDetail.DesignApproved;

                        basicInfoDb.DesignApprovalDate = basicInfoDb.DesignApprovalDate == null
                            ? basicInfoDb.DesignApprovalDate : heisIdentificationDetail.DesignApprovalDate;

                        basicInfoDb.TotalApprovedProjectCost = heisIdentificationDetail.TotalApprovedProjectCost <= 0
                            ? basicInfoDb.TotalApprovedProjectCost : heisIdentificationDetail.TotalApprovedProjectCost;

                        basicInfoDb.TotalDynamicHead = heisIdentificationDetail.TotalDynamicHead <= 0
                           ? basicInfoDb.TotalDynamicHead : heisIdentificationDetail.TotalDynamicHead;

                        basicInfoDb.PumpType = string.IsNullOrEmpty(heisIdentificationDetail.PumpType)
                           ? basicInfoDb.PumpType : heisIdentificationDetail.PumpType;

                        basicInfoDb.PumpFlowRate = heisIdentificationDetail.PumpFlowRate <= 0
                           ? basicInfoDb.PumpFlowRate : heisIdentificationDetail.PumpFlowRate;

                        basicInfoDb.PowerSourceEfficiency = heisIdentificationDetail.PowerSourceEfficiency <= 0
                           ? basicInfoDb.PowerSourceEfficiency : heisIdentificationDetail.PowerSourceEfficiency;
                        #endregion

                        #region Work Order
                        basicInfoDb.WorkOrderIssued = string.IsNullOrEmpty(heisIdentificationDetail.WorkOrderIssued)
                            ? basicInfoDb.WorkOrderIssued : heisIdentificationDetail.WorkOrderIssued;
                        basicInfoDb.WorkOrderIssueDate = basicInfoDb.WorkOrderIssueDate == null
                            ? basicInfoDb.WorkOrderIssueDate : heisIdentificationDetail.WorkOrderIssueDate;
                        basicInfoDb.WorkOrderAmount = heisIdentificationDetail.WorkOrderAmount <= 0
                            ? basicInfoDb.WorkOrderAmount : heisIdentificationDetail.WorkOrderAmount;
                        basicInfoDb.EstimatedGovtShare = heisIdentificationDetail.EstimatedGovtShare <= 0
                           ? basicInfoDb.EstimatedGovtShare : heisIdentificationDetail.EstimatedGovtShare;
                        basicInfoDb.EstimatedFamerShare = heisIdentificationDetail.EstimatedFamerShare <= 0
                           ? basicInfoDb.EstimatedFamerShare : heisIdentificationDetail.EstimatedFamerShare;
                        basicInfoDb.FarmerShareInCash = heisIdentificationDetail.FarmerShareInCash <= 0
                           ? basicInfoDb.FarmerShareInCash : heisIdentificationDetail.FarmerShareInCash;
                        basicInfoDb.FarmerShareInKind = heisIdentificationDetail.FarmerShareInKind <= 0
                           ? basicInfoDb.FarmerShareInKind : heisIdentificationDetail.FarmerShareInKind;
                        #endregion

                        #region Material Verification (ICR-I)

                        basicInfoDb.MaterialVerified = string.IsNullOrEmpty(heisIdentificationDetail.MaterialVerified)
                            ? basicInfoDb.MaterialVerified : heisIdentificationDetail.MaterialVerified;

                        basicInfoDb.MaterialVerifiedDate = basicInfoDb.MaterialVerifiedDate == null
                            ? basicInfoDb.MaterialVerifiedDate : heisIdentificationDetail.MaterialVerifiedDate;

                        basicInfoDb.ICRIAmountVerified = heisIdentificationDetail.ICRIAmountVerified <= 0
                            ? basicInfoDb.ICRIAmountVerified : heisIdentificationDetail.ICRIAmountVerified;

                        #endregion

                        #region Commissioning Verification (ICR-II)

                        basicInfoDb.CommissioningVerification = string.IsNullOrEmpty(heisIdentificationDetail.CommissioningVerification)
                            ? basicInfoDb.CommissioningVerification : heisIdentificationDetail.CommissioningVerification;

                        basicInfoDb.CommissioningVerificationDate = basicInfoDb.CommissioningVerificationDate == null
                            ? basicInfoDb.CommissioningVerificationDate : heisIdentificationDetail.CommissioningVerificationDate;

                        basicInfoDb.TotalSchemeCostVerified = heisIdentificationDetail.TotalSchemeCostVerified <= 0
                            ? basicInfoDb.TotalSchemeCostVerified : heisIdentificationDetail.TotalSchemeCostVerified;

                        basicInfoDb.ICRIIAmountVerified = heisIdentificationDetail.ICRIIAmountVerified <= 0
                           ? basicInfoDb.ICRIIAmountVerified : heisIdentificationDetail.ICRIIAmountVerified;

                        #endregion

                        #region Third Installment (ICR-III)

                        basicInfoDb.ICRIIIVerification = string.IsNullOrEmpty(heisIdentificationDetail.ICRIIIVerification)
                            ? basicInfoDb.ICRIIIVerification : heisIdentificationDetail.ICRIIIVerification;

                        basicInfoDb.TotalAmountVerified = heisIdentificationDetail.TotalAmountVerified <= 0
                            ? basicInfoDb.TotalAmountVerified : heisIdentificationDetail.TotalAmountVerified;

                        basicInfoDb.ICRIIIQualifyingDate = basicInfoDb.ICRIIIQualifyingDate == null
                            ? basicInfoDb.ICRIIIQualifyingDate : heisIdentificationDetail.ICRIIIQualifyingDate;

                        #endregion

                        var response = await _dbContext.SaveChangesAsync();

                        if (response > 0)
                        {
                            wmsdResponse.ResponseCode    = EnumStatus.Success;;
                            wmsdResponse.ResponseMessage = "Record has been added successfully.";
                            return(wmsdResponse);
                        }
                        else
                        {
                            wmsdResponse.ResponseCode    = EnumStatus.Failed;;
                            wmsdResponse.ResponseMessage = "Failed to update record.";
                            return(wmsdResponse);
                        }
                    }
                    else
                    {
                        wmsdResponse.ResponseCode    = EnumStatus.NotFound;;
                        wmsdResponse.ResponseMessage = "No Record found against given Ids.";
                        return(wmsdResponse);
                    }
                }
            }
            catch (Exception ex)
            {
                wmsdResponse.ResponseCode    = EnumStatus.InternalServer;
                wmsdResponse.ResponseMessage = ex.Message;
                return(wmsdResponse);
            }
        }
Ejemplo n.º 17
0
        public async Task <JsonResult> AjaxMethod(int pageIndex, string sortName, string sortDirection)
        {
            IWaterCourseService waterCourseService = new WaterCourseService();
            WmsdsResponse <WcIdentification> model = new WmsdsResponse <WcIdentification>();

            model.PageIndex = pageIndex;
            model.PageSize  = 10;
            var wmsdsResponse = await waterCourseService.GetWcIdentifications(pageIndex, 0, 0, 0, 0, null);

            model.Collections = wmsdsResponse.Collections;
            model.RecordCount = wmsdsResponse.TotalRecords;
            int startIndex = (pageIndex - 1) * model.PageSize;

            //switch (sortName)
            //{
            //    case "CustomerID":
            //    case "":
            //        if (sortDirection == "ASC")
            //        {
            //            model.Customers = (from customer in entities.Customers
            //                               select customer)
            //                    .OrderBy(customer => customer.CustomerID)
            //                    .Skip(startIndex)
            //                    .Take(model.PageSize).ToList();
            //        }
            //        else
            //        {
            //            model.Customers = (from customer in entities.Customers
            //                               select customer)
            //                    .OrderByDescending(customer => customer.CustomerID)
            //                    .Skip(startIndex)
            //                    .Take(model.PageSize).ToList();
            //        }
            //        break;
            //    case "ContactName":
            //        if (sortDirection == "ASC")
            //        {
            //            model.Customers = (from customer in entities.Customers
            //                               select customer)
            //                    .OrderBy(customer => customer.ContactName)
            //                    .Skip(startIndex)
            //                    .Take(model.PageSize).ToList();
            //        }
            //        else
            //        {
            //            model.Customers = (from customer in entities.Customers
            //                               select customer)
            //                    .OrderByDescending(customer => customer.ContactName)
            //                    .Skip(startIndex)
            //                    .Take(model.PageSize).ToList();
            //        }
            //        break;
            //    case "City":
            //        if (sortDirection == "ASC")
            //        {
            //            model.Customers = (from customer in entities.Customers
            //                               select customer)
            //                    .OrderBy(customer => customer.City)
            //                    .Skip(startIndex)
            //                    .Take(model.PageSize).ToList();
            //        }
            //        else
            //        {
            //            model.Customers = (from customer in entities.Customers
            //                               select customer)
            //                    .OrderByDescending(customer => customer.City)
            //                    .Skip(startIndex)
            //                    .Take(model.PageSize).ToList();
            //        }
            //        break;
            //    case "Country":
            //        if (sortDirection == "ASC")
            //        {
            //            model.Customers = (from customer in entities.Customers
            //                               select customer)
            //                    .OrderBy(customer => customer.Country)
            //                    .Skip(startIndex)
            //                    .Take(model.PageSize).ToList();
            //        }
            //        else
            //        {
            //            model.Customers = (from customer in entities.Customers
            //                               select customer)
            //                    .OrderByDescending(customer => customer.Country)
            //                    .Skip(startIndex)
            //                    .Take(model.PageSize).ToList();
            //        }
            //        break;
            //}

            return(Json(model));
        }
Ejemplo n.º 18
0
        public async Task <ActionResult> AddUpdateWatercourseDetails(FormCollection formCollection)
        {
            try
            {
                int WcIdentificationId       = Convert.ToInt16(formCollection["hdWcIdentificationIdBI"]);
                int WcIdentificationDetailId = Convert.ToInt16(formCollection["hdWcIdentificationDetailsIdBI"]);

                int    ImprovementYearId = Convert.ToInt16(formCollection["ddlImprovementYear"]);
                string ImprovementType   = formCollection["ddlImprovementType"] + "";

                double  Latitude             = Convert.ToDouble(formCollection["txtLatitude"]);
                double  Longitude            = Convert.ToDouble(formCollection["txtLongitude"]);
                string  ProjectName          = formCollection["ddlProjectName"] + "".Replace("--Select--", "");
                string  VillageName          = formCollection["txtVillageName"] + "";
                string  UC                   = formCollection["txtUC"] + "";
                decimal GCA                  = Convert.ToDecimal(formCollection["txtGCA"]);
                decimal CCA                  = Convert.ToDecimal(formCollection["txtCCA"]);
                decimal SanctionedDischarge  = Convert.ToDecimal(formCollection["txtSanctionedDischarge"]);
                decimal DesignDischarge      = Convert.ToDecimal(formCollection["txtDesignDischarge"]);
                string  MoghaType            = formCollection["ddlMoghaType"] + "".Replace("--Select--", "");
                string  GroundwaterQuality   = formCollection["ddlGroundwaterQuality"] + "".Replace("--Select--", "");
                string  NameOfWUAChairman    = formCollection["txtNameOfWUAChairman"] + "";
                string  ContactOfWUAChairman = formCollection["txtContactOfWUAChairman"] + "";
                int     NoOfBeneficiaries    = Convert.ToInt16(formCollection["txtNoOfBeneficiaries"]);
                decimal TotalLength          = Convert.ToDecimal(formCollection["txtTotalLength"]);

                WcIdentificationDetail wcIdentificationDetail = new WcIdentificationDetail();
                wcIdentificationDetail.WcIdentificationId = WcIdentificationId;
                wcIdentificationDetail.Id                     = WcIdentificationDetailId;
                wcIdentificationDetail.Latitude               = Latitude;
                wcIdentificationDetail.Longitude              = Longitude;
                wcIdentificationDetail.ProjectName            = ProjectName;
                wcIdentificationDetail.VillageName            = VillageName;
                wcIdentificationDetail.UC                     = UC;
                wcIdentificationDetail.GCA                    = GCA;
                wcIdentificationDetail.CCA                    = CCA;
                wcIdentificationDetail.SanctionedDischargeLPS = SanctionedDischarge;
                wcIdentificationDetail.DesignDischargeLPS     = DesignDischarge;
                wcIdentificationDetail.MoghaType              = MoghaType;
                wcIdentificationDetail.GroundwaterQuality     = GroundwaterQuality;
                wcIdentificationDetail.WUAChairman            = NameOfWUAChairman;
                wcIdentificationDetail.ChairmanContactNo      = ContactOfWUAChairman;
                wcIdentificationDetail.TotalLengthM           = TotalLength;
                wcIdentificationDetail.ImprovementYearId      = ImprovementYearId;
                wcIdentificationDetail.ImprovementType        = ImprovementType;



                IWaterCourseService waterCourseService = new WaterCourseService();
                var response       = new WmsdsResponse <WcIdentificationDetail>();
                var responseUpdate = new WmsdsResponse <int>();
                if (WcIdentificationDetailId == 0)
                {
                    response = await waterCourseService.AddBasicInformation(wcIdentificationDetail);

                    return(Json(response, JsonRequestBehavior.AllowGet));
                }
                else
                {
                    responseUpdate = await waterCourseService.UpdateBasicInformation(wcIdentificationDetail);

                    return(Json(responseUpdate, JsonRequestBehavior.AllowGet));
                }
            }
            catch (Exception)
            {
                return(Json(new { FormId = 0, HttpStatusCode = HttpStatusCode.NotImplemented }));
            }
        }
Ejemplo n.º 19
0
        /// <summary>
        /// Add Identification of a water course
        /// </summary>
        /// <param name="wcIdentification"></param>
        /// <returns></returns>
        public async Task <WmsdsResponse <int> > AddIdentification(WcIdentification wcIdentification)
        {
            var wmsdResponse = new WmsdsResponse <int>();

            if (wcIdentification == null)
            {
                wmsdResponse.ResponseCode    = EnumStatus.EmptyObject;
                wmsdResponse.ResponseMessage = "Object is empty.";
                return(wmsdResponse);
            }

            if (wcIdentification.DistrictId <= 0 || string.IsNullOrEmpty(wcIdentification.DistrictName))
            {
                wmsdResponse.ResponseCode    = EnumStatus.ValidationFailed;;
                wmsdResponse.ResponseMessage = "DistrictId is a required field.";
                return(wmsdResponse);
            }

            if (wcIdentification.TehsilId <= 0 || string.IsNullOrEmpty(wcIdentification.TehsilName))
            {
                wmsdResponse.ResponseCode    = EnumStatus.ValidationFailed;;
                wmsdResponse.ResponseMessage = "TehsilId is a required field.";
                return(wmsdResponse);
            }

            if (wcIdentification.ChannelId <= 0 || string.IsNullOrEmpty(wcIdentification.ChannelName))
            {
                wmsdResponse.ResponseCode    = EnumStatus.ValidationFailed;;
                wmsdResponse.ResponseMessage = "Channel Name is a required field.";
                return(wmsdResponse);
            }
            if (wcIdentification.WaterCourseId <= 0 || string.IsNullOrEmpty(wcIdentification.WaterCourseNo))
            {
                wmsdResponse.ResponseCode    = EnumStatus.ValidationFailed;;
                wmsdResponse.ResponseMessage = "WaterCourse No is a required field.";
                return(wmsdResponse);
            }

            //Check If WcIdentification Already Exists with Regular Status
            //if (wcIdentification.ImprovementType == EnumWcImprovementType.Regular.ToString() && await IsWcIdentificationAlreadyExist(wcIdentification))
            //{
            //    wmsdResponse.ResponseCode = EnumStatus.AlreadyExist;
            //    wmsdResponse.ResponseMessage = "Watercourse already exists.";
            //    return wmsdResponse;
            //}

            //if (wcIdentification.ImprovementType.Equals(EnumWcImprovementType.Additional.ToString(), StringComparison.OrdinalIgnoreCase))
            //{
            //    if (!await IsWcIdentificationAlreadyExist(wcIdentification))
            //    {
            //        wmsdResponse.ResponseCode = EnumStatus.NotFound;
            //        wmsdResponse.ResponseMessage = "No Watercourse found with Regular Status.";
            //        return wmsdResponse;
            //    }
            //}

            if (await IsWcIdentificationAlreadyExist(wcIdentification))
            {
                wmsdResponse.ResponseCode    = EnumStatus.AlreadyExist;
                wmsdResponse.ResponseMessage = "Watercourse already exists.";
                return(wmsdResponse);
            }
            //Check if status is Addation than there must be a regular water course
            try
            {
                using (var _dbContext = new EntityContext())
                {
                    _dbContext.WcIdentifications.Add(wcIdentification);
                    var response = await _dbContext.SaveChangesAsync();

                    if (response > 0)
                    {
                        wmsdResponse.ResponseCode    = EnumStatus.Success;;
                        wmsdResponse.ResponseMessage = "Identicification has been added successfully.";
                        return(wmsdResponse);
                    }
                    else
                    {
                        wmsdResponse.ResponseCode    = EnumStatus.Failed;;
                        wmsdResponse.ResponseMessage = "Failed to add channel.";
                        return(wmsdResponse);
                    }
                }
            }
            catch (Exception ex)
            {
                wmsdResponse.ResponseCode    = EnumStatus.InternalServer;
                wmsdResponse.ResponseMessage = ex.Message;
                return(wmsdResponse);
            }
        }
Ejemplo n.º 20
0
        /// <summary>
        /// Step1: Update BasicInformation
        /// </summary>
        /// <param name="wcIdentificationDetail"></param>
        /// <returns></returns>
        public async Task <WmsdsResponse <int> > UpdateBasicInformation(WcIdentificationDetail wcIdentificationDetail)
        {
            var wmsdResponse = new WmsdsResponse <int>();

            if (wcIdentificationDetail == null)
            {
                wmsdResponse.ResponseCode    = EnumStatus.EmptyObject;
                wmsdResponse.ResponseMessage = "Object is empty.";
                return(wmsdResponse);
            }

            if (wcIdentificationDetail.WcIdentificationId <= 0)
            {
                wmsdResponse.ResponseCode    = EnumStatus.EmptyObject;
                wmsdResponse.ResponseMessage = "Parent Identification key is empty.";
                return(wmsdResponse);
            }
            if (wcIdentificationDetail.Id <= 0)
            {
                wmsdResponse.ResponseCode    = EnumStatus.EmptyObject;
                wmsdResponse.ResponseMessage = "Id is missing.";
                return(wmsdResponse);
            }

            try
            {
                using (var _dbContext = new EntityContext())
                {
                    var basicInfoDb = await _dbContext.WcIdentificationDetails
                                      .Where(c => c.Id == wcIdentificationDetail.Id &&
                                             c.WcIdentificationId == wcIdentificationDetail.WcIdentificationId)
                                      .SingleOrDefaultAsync();

                    if (basicInfoDb != null)
                    {
                        basicInfoDb.ProjectId = wcIdentificationDetail.ProjectId <= 0
                            ? basicInfoDb.ProjectId: wcIdentificationDetail.ProjectId;

                        basicInfoDb.ProjectName = string.IsNullOrEmpty(wcIdentificationDetail.ProjectName)
                            ? basicInfoDb.ProjectName : wcIdentificationDetail.ProjectName;

                        basicInfoDb.VillageName = string.IsNullOrEmpty(wcIdentificationDetail.VillageName)
                            ? basicInfoDb.VillageName : wcIdentificationDetail.VillageName;

                        basicInfoDb.UC = string.IsNullOrEmpty(wcIdentificationDetail.UC)
                             ? basicInfoDb.UC : wcIdentificationDetail.UC;

                        basicInfoDb.GCA = wcIdentificationDetail.GCA <= 0
                              ? basicInfoDb.GCA : wcIdentificationDetail.GCA;

                        basicInfoDb.CCA = wcIdentificationDetail.CCA <= 0
                              ? basicInfoDb.CCA : wcIdentificationDetail.CCA;

                        basicInfoDb.SanctionedDischargeLPS = wcIdentificationDetail.SanctionedDischargeLPS <= 0
                             ? basicInfoDb.SanctionedDischargeLPS : wcIdentificationDetail.SanctionedDischargeLPS;

                        basicInfoDb.DesignDischargeLPS = wcIdentificationDetail.DesignDischargeLPS <= 0
                             ? basicInfoDb.DesignDischargeLPS : wcIdentificationDetail.DesignDischargeLPS;

                        basicInfoDb.MoghaType = string.IsNullOrEmpty(wcIdentificationDetail.MoghaType)
                             ? basicInfoDb.MoghaType : wcIdentificationDetail.MoghaType;

                        basicInfoDb.GroundwaterQuality = string.IsNullOrEmpty(wcIdentificationDetail.GroundwaterQuality)
                              ? basicInfoDb.GroundwaterQuality : wcIdentificationDetail.GroundwaterQuality;

                        basicInfoDb.WUAChairman = string.IsNullOrEmpty(wcIdentificationDetail.WUAChairman)
                               ? basicInfoDb.WUAChairman : wcIdentificationDetail.WUAChairman;

                        basicInfoDb.NoOfBeneficiaries = wcIdentificationDetail.NoOfBeneficiaries <= 0
                                ? basicInfoDb.NoOfBeneficiaries : wcIdentificationDetail.NoOfBeneficiaries;

                        basicInfoDb.TotalLengthM = wcIdentificationDetail.TotalLengthM <= 0
                                ? basicInfoDb.TotalLengthM : wcIdentificationDetail.TotalLengthM;

                        basicInfoDb.PreviousLinedLengthM = wcIdentificationDetail.PreviousLinedLengthM <= 0
                                ? basicInfoDb.PreviousLinedLengthM : wcIdentificationDetail.PreviousLinedLengthM;

                        basicInfoDb.Latitude = wcIdentificationDetail.Latitude <= 0
                                ? basicInfoDb.Latitude : wcIdentificationDetail.Latitude;

                        basicInfoDb.Longitude = wcIdentificationDetail.Longitude <= 0
                                ? basicInfoDb.Longitude : wcIdentificationDetail.Longitude;

                        var response = await _dbContext.SaveChangesAsync();

                        if (response > 0)
                        {
                            wmsdResponse.ResponseCode    = EnumStatus.Success;;
                            wmsdResponse.ResponseMessage = "Record has been added successfully.";
                            return(wmsdResponse);
                        }
                        else
                        {
                            wmsdResponse.ResponseCode    = EnumStatus.Failed;;
                            wmsdResponse.ResponseMessage = "Failed to update record.";
                            return(wmsdResponse);
                        }
                    }
                    else
                    {
                        wmsdResponse.ResponseCode    = EnumStatus.NotFound;;
                        wmsdResponse.ResponseMessage = "No Record found against given Ids.";
                        return(wmsdResponse);
                    }
                }
            }
            catch (Exception ex)
            {
                wmsdResponse.ResponseCode    = EnumStatus.InternalServer;
                wmsdResponse.ResponseMessage = ex.Message;
                return(wmsdResponse);
            }
        }
Ejemplo n.º 21
0
        /// <summary>
        /// Step3: Add/Update ICR1 & ICR2
        /// </summary>
        /// <param name="wcIdentificationDetail"></param>
        /// <returns></returns>
        public async Task <WmsdsResponse <int> > AddUpdateICR1AndICR2(WcIdentificationDetail wcIdentificationDetail)
        {
            var wmsdResponse = new WmsdsResponse <int>();

            if (wcIdentificationDetail == null)
            {
                wmsdResponse.ResponseCode    = EnumStatus.EmptyObject;
                wmsdResponse.ResponseMessage = "Object is empty.";
                return(wmsdResponse);
            }

            if (wcIdentificationDetail.WcIdentificationId <= 0)
            {
                wmsdResponse.ResponseCode    = EnumStatus.EmptyObject;
                wmsdResponse.ResponseMessage = "Parent Identification key is empty.";
                return(wmsdResponse);
            }
            if (wcIdentificationDetail.Id <= 0)
            {
                wmsdResponse.ResponseCode    = EnumStatus.EmptyObject;
                wmsdResponse.ResponseMessage = "Id is missing.";
                return(wmsdResponse);
            }

            try
            {
                using (var _dbContext = new EntityContext())
                {
                    var basicInfoDb = await _dbContext.WcIdentificationDetails
                                      .Where(c => c.Id == wcIdentificationDetail.Id &&
                                             c.WcIdentificationId == wcIdentificationDetail.WcIdentificationId)
                                      .SingleOrDefaultAsync();

                    if (basicInfoDb != null)
                    {
                        basicInfoDb.ICR1ApprovedStatus = string.IsNullOrEmpty(wcIdentificationDetail.ICR1ApprovedStatus)
                            ? basicInfoDb.ICR1ApprovedStatus : wcIdentificationDetail.ICR1ApprovedStatus;

                        basicInfoDb.ICR1ReleasedAmount = wcIdentificationDetail.ICR1ReleasedAmount <= 0
                            ? basicInfoDb.ICR1ReleasedAmount : wcIdentificationDetail.ICR1ReleasedAmount;

                        basicInfoDb.ICR2ApprovedStatus = string.IsNullOrEmpty(wcIdentificationDetail.ICR2ApprovedStatus)
                            ? basicInfoDb.ICR2ApprovedStatus : wcIdentificationDetail.ICR2ApprovedStatus;

                        basicInfoDb.ICR2ReleasedAmount = wcIdentificationDetail.ICR2ReleasedAmount <= 0
                             ? basicInfoDb.ICR2ReleasedAmount : wcIdentificationDetail.ICR2ReleasedAmount;


                        var response = await _dbContext.SaveChangesAsync();

                        if (response > 0)
                        {
                            wmsdResponse.ResponseCode    = EnumStatus.Success;;
                            wmsdResponse.ResponseMessage = "Record has been updated successfully.";
                            return(wmsdResponse);
                        }
                        else
                        {
                            wmsdResponse.ResponseCode    = EnumStatus.Failed;;
                            wmsdResponse.ResponseMessage = "Failed to update record.";
                            return(wmsdResponse);
                        }
                    }
                    else
                    {
                        wmsdResponse.ResponseCode    = EnumStatus.NotFound;;
                        wmsdResponse.ResponseMessage = "No Record found against given Ids.";
                        return(wmsdResponse);
                    }
                }
            }
            catch (Exception ex)
            {
                wmsdResponse.ResponseCode    = EnumStatus.InternalServer;
                wmsdResponse.ResponseMessage = ex.Message;
                return(wmsdResponse);
            }
        }
Ejemplo n.º 22
0
        public async Task <WmsdsResponse <DistrictWiseDto> > GetDistrictWiseOverview(int districtId)
        {
            var wmsdResponse = new WmsdsResponse <DistrictWiseDto>();

            wmsdResponse.DataObject = new DistrictWiseDto();
            try
            {
                using (var dbContext = new EntityContext())
                {
                    var improvedWcCount = await(from wc in dbContext.WcIdentifications
                                                from wd in dbContext.WcIdentificationDetails
                                                where wc.Id == wd.WcIdentificationId &&
                                                wc.DistrictId == districtId
                                                select wc.Id).CountAsync();

                    var totalWcCourse = await dbContext.WaterCourses.Where(wc => wc.DistrictId == districtId).CountAsync();

                    wmsdResponse.DataObject.ImprovedWaterCourse   = improvedWcCount;
                    wmsdResponse.DataObject.UnImprovedWaterCourse = totalWcCourse - improvedWcCount;

                    //Watercourse Improvement Status
                    var wcImprovementStatus = await(from wc in dbContext.WcIdentifications
                                                    from wd in dbContext.WcIdentificationDetails
                                                    where wc.Id == wd.WcIdentificationId &&
                                                    wc.DistrictId == districtId
                                                    group wd by new { wd.ImprovementType } into g
                                                    select new KeyValueDto
                    {
                        name = g.Key.ImprovementType,
                        y    = g.Count(x => x.WcIdentificationId != 0)
                    }).ToListAsync();

                    wmsdResponse.DataObject.KeyValueDtos = wcImprovementStatus;

                    //Get Improved Length
                    var wcImprovementLength = await(from wc in dbContext.WcIdentifications
                                                    from wd in dbContext.WcIdentificationDetails
                                                    where wc.Id == wd.WcIdentificationId &&
                                                    wc.DistrictId == districtId
                                                    select wd).ToListAsync();

                    var earthenTotalLen = wcImprovementLength.Sum(x => x.EarthenLengthM);
                    var linedTotalLen   = wcImprovementLength.Sum(x => x.LiningLengthM);

                    wmsdResponse.ResponseCode       = EnumStatus.Success;
                    wmsdResponse.DataObject.Earthen = (int)earthenTotalLen / 1000;//KM
                    //wmsdResponse.DataObject.Earthen = wmsdResponse.DataObject.Earthen / 1000;//"000KM"

                    wmsdResponse.DataObject.Lined = (int)linedTotalLen / 1000;//KM
                    //  wmsdResponse.DataObject.Lined = wmsdResponse.DataObject.Lined / 1000;//"000KM"

                    wmsdResponse.DataObject.TotalLength = wmsdResponse.DataObject.Earthen + wmsdResponse.DataObject.Lined;

                    //Tehsil wise Watercourse Improvement
                    var tehsilWiseData = await(from wc in dbContext.WcIdentifications
                                               from wd in dbContext.WcIdentificationDetails
                                               where wc.Id == wd.WcIdentificationId &&
                                               wc.DistrictId == districtId
                                               group wd by new { wc.TehsilName, wc.TehsilId } into g
                                               select new
                    {
                        Tehsil   = g.Key.TehsilName,
                        TehsilId = g.Key.TehsilId
                    }).ToListAsync();



                    wmsdResponse.DataObject.TehsilWiseDtos = new List <TehsilWiseDto>();
                    foreach (var tehsilWise in tehsilWiseData)
                    {
                        var tehsilWiseDto   = new TehsilWiseDto();
                        var tehsilWiseCount = await(from wc in dbContext.WcIdentifications
                                                    from wd in dbContext.WcIdentificationDetails
                                                    where wc.Id == wd.WcIdentificationId &&
                                                    wc.DistrictId == districtId &&
                                                    wc.TehsilId == tehsilWise.TehsilId
                                                    select wc.Id).CountAsync();

                        var totalWcCourseThWise = await dbContext.WaterCourses
                                                  .Where(wc => wc.DistrictId == districtId && wc.TehsilId == tehsilWise.TehsilId).CountAsync();

                        tehsilWiseDto.ImprovedWaterCourse   = tehsilWiseCount;
                        tehsilWiseDto.UnImprovedWaterCourse = totalWcCourseThWise - tehsilWiseCount;
                        tehsilWiseDto.Tehsil = tehsilWise.Tehsil;
                        wmsdResponse.DataObject.TehsilWiseDtos.Add(tehsilWiseDto);
                    }


                    wmsdResponse.ResponseCode    = EnumStatus.Success;
                    wmsdResponse.ResponseMessage = "Success";
                    return(wmsdResponse);
                }
            }
            catch (Exception ex)
            {
                wmsdResponse.ResponseCode    = EnumStatus.Error;
                wmsdResponse.ResponseMessage = ex.Message;
                return(wmsdResponse);
            }
        }
Ejemplo n.º 23
0
        /// <summary>
        /// Step4: Add Update FCR
        /// </summary>
        /// <param name="wcIdentificationDetail"></param>
        /// <returns></returns>
        public async Task <WmsdsResponse <int> > AddUpdateFCR(WcIdentificationDetail wcIdentificationDetail)
        {
            var wmsdResponse = new WmsdsResponse <int>();

            if (wcIdentificationDetail == null)
            {
                wmsdResponse.ResponseCode    = EnumStatus.EmptyObject;
                wmsdResponse.ResponseMessage = "Object is empty.";
                return(wmsdResponse);
            }

            if (wcIdentificationDetail.WcIdentificationId <= 0)
            {
                wmsdResponse.ResponseCode    = EnumStatus.EmptyObject;
                wmsdResponse.ResponseMessage = "Parent Identification key is empty.";
                return(wmsdResponse);
            }
            if (wcIdentificationDetail.Id <= 0)
            {
                wmsdResponse.ResponseCode    = EnumStatus.EmptyObject;
                wmsdResponse.ResponseMessage = "Id is missing.";
                return(wmsdResponse);
            }

            try
            {
                using (var _dbContext = new EntityContext())
                {
                    var basicInfoDb = await _dbContext.WcIdentificationDetails
                                      .Where(c => c.Id == wcIdentificationDetail.Id &&
                                             c.WcIdentificationId == wcIdentificationDetail.WcIdentificationId)
                                      .SingleOrDefaultAsync();

                    if (basicInfoDb != null)
                    {
                        basicInfoDb.FCRApprovedStatus = string.IsNullOrEmpty(wcIdentificationDetail.FCRApprovedStatus)
                            ? basicInfoDb.FCRApprovedStatus : wcIdentificationDetail.FCRApprovedStatus;

                        basicInfoDb.FCRLinedLength = wcIdentificationDetail.FCRLinedLength <= 0
                            ? basicInfoDb.FCRLinedLength : wcIdentificationDetail.FCRLinedLength;

                        basicInfoDb.LinedPercentage = wcIdentificationDetail.LinedPercentage <= 0
                            ? basicInfoDb.LinedPercentage : wcIdentificationDetail.LinedPercentage;

                        basicInfoDb.TotalCostOfCivilWrkVerfied = wcIdentificationDetail.TotalCostOfCivilWrkVerfied <= 0
                             ? basicInfoDb.TotalCostOfCivilWrkVerfied : wcIdentificationDetail.TotalCostOfCivilWrkVerfied;


                        basicInfoDb.FCREarthenWorks = wcIdentificationDetail.FCREarthenWorks <= 0
                             ? basicInfoDb.FCREarthenWorks : wcIdentificationDetail.FCREarthenWorks;

                        basicInfoDb.FCRMasonryWorks = wcIdentificationDetail.FCRMasonryWorks <= 0
                             ? basicInfoDb.FCRMasonryWorks : wcIdentificationDetail.FCRMasonryWorks;

                        basicInfoDb.TotalSchemeCost = wcIdentificationDetail.TotalSchemeCost <= 0
                             ? basicInfoDb.TotalSchemeCost : wcIdentificationDetail.TotalSchemeCost;

                        basicInfoDb.FCRPcpSegmentSize = string.IsNullOrEmpty(wcIdentificationDetail.FCRPcpSegmentSize)
                             ? basicInfoDb.FCRPcpSegmentSize : wcIdentificationDetail.FCRPcpSegmentSize;

                        basicInfoDb.FCRPcpSegment = wcIdentificationDetail.FCRPcpSegment <= 0
                             ? basicInfoDb.FCRPcpSegment : wcIdentificationDetail.FCRPcpSegment;

                        basicInfoDb.FCRPipeType = string.IsNullOrEmpty(wcIdentificationDetail.FCRPipeType)
                             ? basicInfoDb.FCRPipeType : wcIdentificationDetail.FCRPipeType;

                        basicInfoDb.FCRSizeOfPipeInch = wcIdentificationDetail.FCRSizeOfPipeInch <= 0
                             ? basicInfoDb.FCRSizeOfPipeInch : wcIdentificationDetail.FCRSizeOfPipeInch;

                        basicInfoDb.FCRLengthOfPipeM = wcIdentificationDetail.FCRLengthOfPipeM <= 0
                             ? basicInfoDb.FCRLengthOfPipeM : wcIdentificationDetail.FCRLengthOfPipeM;


                        basicInfoDb.FCRNakkas = wcIdentificationDetail.FCRNakkas <= 0
                             ? basicInfoDb.FCRNakkas : wcIdentificationDetail.FCRNakkas;

                        basicInfoDb.FCRCulverts = wcIdentificationDetail.FCRCulverts <= 0
                             ? basicInfoDb.FCRCulverts : wcIdentificationDetail.FCRCulverts;

                        basicInfoDb.FCRBuffaloWallow = wcIdentificationDetail.FCRBuffaloWallow <= 0
                             ? basicInfoDb.FCRBuffaloWallow : wcIdentificationDetail.FCRBuffaloWallow;

                        basicInfoDb.FCRDistributionBox = wcIdentificationDetail.FCRDistributionBox <= 0
                             ? basicInfoDb.FCRDistributionBox : wcIdentificationDetail.FCRDistributionBox;

                        basicInfoDb.FCRWaterStorageTank = wcIdentificationDetail.FCRWaterStorageTank <= 0
                             ? basicInfoDb.FCRWaterStorageTank : wcIdentificationDetail.FCRWaterStorageTank;

                        basicInfoDb.FCRDropStructure = wcIdentificationDetail.FCRDropStructure <= 0
                             ? basicInfoDb.FCRDropStructure : wcIdentificationDetail.FCRDropStructure;

                        basicInfoDb.FCROthers = wcIdentificationDetail.FCROthers <= 0
                             ? basicInfoDb.FCROthers : wcIdentificationDetail.FCROthers;


                        var response = await _dbContext.SaveChangesAsync();

                        if (response > 0)
                        {
                            wmsdResponse.ResponseCode    = EnumStatus.Success;;
                            wmsdResponse.ResponseMessage = "Record has been updated successfully.";
                            return(wmsdResponse);
                        }
                        else
                        {
                            wmsdResponse.ResponseCode    = EnumStatus.Failed;;
                            wmsdResponse.ResponseMessage = "Failed to update record.";
                            return(wmsdResponse);
                        }
                    }
                    else
                    {
                        wmsdResponse.ResponseCode    = EnumStatus.NotFound;;
                        wmsdResponse.ResponseMessage = "No Record found against given Ids.";
                        return(wmsdResponse);
                    }
                }
            }
            catch (Exception ex)
            {
                wmsdResponse.ResponseCode    = EnumStatus.InternalServer;
                wmsdResponse.ResponseMessage = ex.Message;
                return(wmsdResponse);
            }
        }