Пример #1
0
        protected void AjaxUploadAttech_UploadComplete(object sender, AjaxControlToolkit.AjaxFileUploadEventArgs e)
        {
            FileInfo fi  = new FileInfo(e.FileName);
            string   ext = fi.Extension;

            string[] data = HttpUtility.UrlDecode(Request.Cookies["asp_act"].Value.ToString()).Split('|');
            if (data[1] == "2")
            {
                string fileID   = Fn.ExenID("INSERT INTO tblEmpDocs (EmpID,FileTitle, FileExt) VALUES (" + data[0] + ", '" + fi.Name + "', '" + ext + "');select SCOPE_IDENTITY()");
                string filePath = Server.MapPath("~") + "/Uploads/EmpDocuments/" + fileID + ext;
                AjaxUploadAttech.SaveAs(filePath);
            }
            else
            {
                Fn.Exec(@"UPDATE tblEmployee SET PhotoExtension='" + ext + "' WHERE EmpID=" + data[0]);
                string filePath = Server.MapPath("~") + "/Uploads/EmployeePhoto/" + data[0] + ext;
                AjaxUploadAttech.SaveAs(filePath);
                if (fi.Extension.ToUpper() == ".JPEG" || fi.Extension.ToUpper() == ".JPG" || fi.Extension.ToUpper() == ".BMP" || fi.Extension.ToUpper() == ".PNG" || fi.Extension.ToUpper() == ".GIF")
                {
                    Bitmap Thumbnail       = CreateThumbnail(filePath, 32, 32);
                    string SaveAsThumbnail = System.IO.Path.Combine(HttpContext.Current.Server.MapPath("~") + "/Uploads/EmployeePhoto/", Convert.ToString(data[0]) + "A" + fi.Extension);
                    Thumbnail.Save(SaveAsThumbnail);
                }

                if (fi.Extension.ToUpper() == ".JPEG" || fi.Extension.ToUpper() == ".JPG" || fi.Extension.ToUpper() == ".BMP" || fi.Extension.ToUpper() == ".PNG" || fi.Extension.ToUpper() == ".GIF")
                {
                    Bitmap Thumbnail       = CreateThumbnail(filePath, 75, 75);
                    string SaveAsThumbnail = System.IO.Path.Combine(HttpContext.Current.Server.MapPath("~") + "/Uploads/EmployeePhoto/", Convert.ToString(data[0]) + "B" + fi.Extension);
                    Thumbnail.Save(SaveAsThumbnail);
                }
            }
        }
        public static string SaveSalary(string SalaryID, string CompleteData)
        {
            string[] d = CompleteData.Split('½');
            if (SalaryID == "0")
            {
                string id = Fn.ExenID(@"INSERT INTO tbl_PayrollEmployeeMonthlySalary (EmpID, SalaryDate, BasicPay, HouseRent, ConveyanceAllowance, IntegratedAllowSplPay, MedicalAllowCurrentBPay, AdhocAllowance7Point5, MiscEidAdvance, ComputerAllowance, AdhocAllowanceEmpty, EntertainmentAllowance, AdhocRelief10Percent, DeputationAllowance, QualificationAllowance, AAllow2013_10Percent, SplReliefAllowance30Percent, DrivingAllowance, AdhocAllowBPNov10_50percent, Arrears, SplAllowJuneBasic20Percent, GrossSalary, GPF, GPFInstallments, StaffLedger, IncomeTax, TradeTax, GroupInsurance, PersonnelInstalment, GRLSLoan, HajFund, BenevolentFund, CarAdvance, MotorCycle, HouseBuilding, SalarySlipCharges, PUTMicroFinance, UnionFund, Shop, EidAdvanceSPL, GovtResidence10Percent, TotalDeductions, NetSalary, Is_SemiAutoSalary) 
                                    VALUES ('" + d[0] + "','" + d[1] + "','" + d[2] + "','" + d[3] + "','" + d[4] + "','" + d[5] + "','" + d[6] + "','" + d[7] + "','" + d[8] + "','" + d[9] + "','" + d[10] + "','" + d[11] + "','" + d[12] + "','" + d[13] + "','" + d[14] + "','" + d[15] + "','" + d[16] + "','" + d[17] + "','" + d[18] + "','" + d[19] + "','" + d[20] + "','" + d[21] + "','" + d[22] + "','" + d[23] + "','" + d[24] + "','" + d[25] + "','" + d[26] + "','" + d[27] + "','" + d[28] + "','" + d[29] + "','" + d[30] + "','" + d[31] + "','" + d[32] + "','" + d[33] + "','" + d[34] + "','" + d[35] + "','" + d[36] + "','" + d[37] + "','" + d[38] + "','" + d[39] + "','" + d[40] + "','" + d[41] + "','" + d[42] + "','0' ); Select Scope_Identity();");
                Fn.Exec("usp_PayrollGPFBalanceUpdate '" + d[0] + "', '" + d[22] + "', '" + d[1] + "'");
                return(id);
            }
            else
            {
                //=========>Fn.Exec("update tbl_PayrollGPFBalance set Balance = Balance + (Select (-1) * GPF from tbl_PayrollEmployeeMonthlySalary where MonthlySalaryID = '" + SalaryID + "')  where EmpID = " + d[0]);

                //Fn.Exec(@"UPDATE tbl_PayrollEmployeeMonthlySalary SET EmpID = '" + d[0] + "', SalaryDate = '" + d[1] + "', BasicPay = '" + d[2] + "', HouseRent = '" + d[3] + "', ConveyanceAllowance = '" + d[4] + "', IntegratedAllowSplPay = '" + d[5] + "', MedicalAllowCurrentBPay = '" + d[6] + "', AdhocAllowance7Point5 = '" + d[7] + "', MiscEidAdvance = '" + d[8] + "', ComputerAllowance = '" + d[9] + "', AdhocAllowanceEmpty = '" + d[10] + "', EntertainmentAllowance = '" + d[11] + "', AdhocRelief10Percent = '" + d[12] + "', DeputationAllowance = '" + d[13] + "', QualificationAllowance = '" + d[14] + "', AAllow2013_10Percent = '" + d[15] + "', SplReliefAllowance30Percent = '" + d[16] + "', DrivingAllowance = '" + d[17] + "', AdhocAllowBPNov10_50percent = '" + d[18] + "', Arrears = '" + d[19] + "', SplAllowJuneBasic20Percent = '" + d[20] + "', GrossSalary = '" + d[21] + "', GPF = '" + d[22] + "', GPFInstallments = '" + d[23] + "', StaffLedger = '" + d[24] + "', IncomeTax = '" + d[25] + "', TradeTax = '" + d[26] + "', GroupInsurance = '" + d[27] + "', PersonnelInstalment = '" + d[28] + "', GRLSLoan = '" + d[29] + "', HajFund = '" + d[30] + "', BenevolentFund = '" + d[31] + "', CarAdvance = '" + d[32] + "', MotorCycle = '" + d[33] + "', HouseBuilding = '" + d[34] + "', SalarySlipCharges = '" + d[35] + "', PUTMicroFinance = '" + d[36] + "', UnionFund = '" + d[37] + "', Shop = '" + d[38] + "', EidAdvanceSPL = '" + d[39] + "', GovtResidence10Percent = '" + d[40] + "', TotalDeductions = '" + d[41] + "', NetSalary = '" + d[42] + "' where MonthlySalaryID = " + SalaryID);

                Fn.Exec(@"UPDATE tbl_PayrollEmployeeMonthlySalary SET 
EmpID ='" + d[0] + @"', BasicPay ='" + d[1] + @"', HouseRent ='" + d[2] + @"', ConveyanceAllowance ='" + d[3] + @"', MedicalAllowCurrentBPay ='" + d[4] + @"', MiscEidAdvance ='" + d[5] + @"', ComputerAllowance ='" + d[6] + @"', EntertainmentAllowance ='" + d[7] + @"', DeputationAllowance ='" + d[8] + @"', 
                         ProjectBaseAllowance ='" + d[9] + @"', Arrears ='" + d[10] + @"', GrossSalary ='" + d[11] + @"', GPF ='" + d[12] + @"', GPFInstallments ='" + d[13] + @"', IncomeTax ='" + d[14] + @"', GroupInsurance ='" + d[15] + @"', PersonnelInstalment ='" + d[16] + @"', CarAdvance ='" + d[17] + @"', MotorCycle ='" + d[18] + @"', HouseBuilding ='" + d[19] + @"', CashAdvanceLoan ='" + d[20] + @"', 
                         TotalDeductions ='" + d[21] + @"', NetSalary ='" + d[22] + @"', Is_SemiAutoSalary =0
where MonthlySalaryID = " + SalaryID);


                //=========>Fn.Exec("usp_PayrollGPFBalanceUpdate '" + d[0] + "', '" + d[22] + "', '" + d[1] + "'");
                return(SalaryID);
            }
        }
Пример #3
0
        public static string SaveEmpParticular(string Vals)
        {
            var frmdata = Vals;

            string[] d = frmdata.Split('½');
            Fn.Exec(@"UPDATE       tblEmployee
SET                BPay ='" + d[0] + @"'
WHERE        (EmpID =  '" + d[23] + @"')");
            return(Fn.Exec("INSERT INTO tbl_PayrollEmployeeParticulars (BasicPay, RateOfIncrement, MinimumPayScale, DirectorateId, BankId, BankAccountNo, ECRPageNo, CarMaintain, TransferStatus, MoveOver, PickAndDrop, LeaveHaldAverage, UseGovtHouse, Is_Muslim, DepotationAllowance, PersonalLoan, GPFPercentage, GRLS, GRLSInstallments, HouseBuildingAdvance, BasicPayNov2010, BasicPayNov2011, BasicPayJun2015, EmpID) VALUES ('" + d[0] + "','" + d[1] + "','" + d[2] + "','" + d[3] + "','" + d[4] + "','" + d[5] + "','" + d[6] + "','" + d[7] + "','" + d[8] + "','" + d[9] + "','" + d[10] + "','" + d[11] + "','" + d[12] + "','" + d[13] + "','" + d[14] + "','" + d[15] + "','" + d[16] + "','" + d[17] + "','" + d[18] + "','" + d[19] + "','" + d[20] + "','" + d[21] + "','" + d[22] + "','" + d[23] + "')"));
        }
Пример #4
0
 public static string ActivateDeactivate(string ID, string Status)
 {
     if (Status == "true")
     {
         Fn.Exec("Update TblHResources SET U_Status = 0 WHERE User_ID = " + ID);
         return("Deactivated Successfully");
     }
     else
     {
         Fn.Exec("Update TblHResources SET U_Status = 1 WHERE User_ID = " + ID);
         return("Activated Successfully");
     }
 }
Пример #5
0
        public void ProcessRequest(HttpContext context)
        {
            MyClass Fn = new MyClass();

            string[] dataID = Fn.CleanSQL(HttpUtility.UrlDecode(context.Request.QueryString["id"])).Split('ǁ');

            {
                try
                {
                    context.Response.ContentType = "text/HTML";
                    switch (Convert.ToInt32(dataID[0]))
                    {
                    case 0:
                        string formdata = HttpUtility.UrlDecode(context.Request.Form["vls"]);
                        string formcost = HttpUtility.UrlDecode(context.Request.Form["rt1"]);
                        string Case0ID  = "0";
                        if (formdata.Contains('½'))
                        {
                            Case0ID = Fn.ExenID(@"INSERT INTO VehicleProblem
                         (Problem, Date, WorkshopID, Vehicle_id, DriverEmpID, Description)
                         VALUES        ('" + formdata.Split('½')[0] + @"','" + formdata.Split('½')[1] + @"','" + formdata.Split('½')[2] + @"','" + formdata.Split('½')[3] + @"','" + formdata.Split('½')[4] + @"','" + formdata.Split('½')[5] + @"'); select SCOPE_IDENTITY()");

                            if (formcost.Contains('¼'))
                            {
                                foreach (string item in formcost.Split('¼'))
                                {
                                    if (item.Contains('½'))
                                    {
                                        Fn.Exec(@"INSERT INTO VehicleProblemCost
                         (VehicleProblemID, CostFor, Descrtiption, CostAmount)
VALUES        ('" + Case0ID + @"','" + item.Split('½')[0] + @"','" + item.Split('½')[1] + @"','" + item.Split('½')[2] + @"')");
                                    }
                                }
                            }
                        }


                        context.Response.Write(Case0ID);
                        break;

                    case 1:
                        context.Response.Write(Fn.HTMLTableWithID_TR_Tag(@"SELECT        VehicleProblem.VehicleProblemID, VehicleProblem.Problem, VehicleProblem.Date, Vehicle.Number Vehicle, Workshop.Workshop_Name Workshop, ISNULL(tblEmployee.FName,'')+' '+ ISNULL(tblEmployee.LName,'') AS Driver
FROM            VehicleProblem INNER JOIN
                         Vehicle ON VehicleProblem.Vehicle_id = Vehicle.Vehicle_id INNER JOIN
                         Workshop ON VehicleProblem.WorkshopID = Workshop.Workshop_Id INNER JOIN
                         tblEmployee ON VehicleProblem.DriverEmpID = tblEmployee.EmpID", "tblReq"));
                        break;

                    default:
                        context.Response.Write("<p>Contents not available</p>");
                        break;
                    }
                }
                catch
                {
                    context.Response.ContentType = "text/HTML";
                    context.Response.Write("<p>Contents not available</p>");
                }
            }
        }
Пример #6
0
        protected void btnSearch_Click(object sender, EventArgs e)
        {
            Fn.Exec(@"EXEC sp_GenerateSalary " + Convert.ToString(ddlMonth.SelectedValue) + ", " + Convert.ToString(ddlSalaryYear.SelectedValue) + ", " + Convert.ToString(ddlOfficeType.SelectedValue));
            DataSet ds = new DataSet();

            ds = Fn.FillDSet("EXEC usp_DirectorateWiseNetSalaryReportByType " + Convert.ToString(ddlMonth.SelectedValue) + ", " + Convert.ToString(ddlSalaryYear.SelectedValue) + ", " + Convert.ToString(ddlOfficeType.SelectedValue));
            ShowReport(ds);
        }
Пример #7
0
        public static String PostFeedback(string name, string email, string subject, string feedback)
        {
            string tomail = Fn.GetRecords("SELECT Email FROM TblHResources WHERE (User_ID = 1)")[0];

            Fn.Exec("INSERT INTO TblFeedback(fUser, fEmail, fSubject, fComments)VALUES ('" + Fn.CleanSQL(name) + "', '" + Fn.CleanSQL(email) + "', '" + Fn.CleanSQL(subject) + "', '" + Fn.CleanSQL(feedback) + "')");
            Fn.SendEmail(tomail, subject + " - " + name, feedback, email);
            return("Thanks for feedback");
        }
Пример #8
0
        public static string GPFOwnContributionSave(string Month, string EmpID, string ContributionAmount, string FromYear, string ToYear)
        {
            int      CurrYear = DateTime.Now.Year;
            DateTime ContributionDate;

            if (Convert.ToInt32(Month) >= 7)
            {
                ContributionDate = new DateTime(Convert.ToInt32(FromYear), Convert.ToInt32(Month), 01);
            }
            else
            {
                ContributionDate = new DateTime(Convert.ToInt32(ToYear), Convert.ToInt32(Month), 01);
            }


            Fn.Exec("if exists (select * from tbl_GPFContributionDetail where EmpID = '" + EmpID + "' and ContributionDate = '" + ContributionDate + "') begin update tbl_GPFContributionDetail set Amount  = '" + ContributionAmount + "'  where EmpID = '" + EmpID + "' and ContributionDate = '" + ContributionDate + "'; end else begin INSERT INTO tbl_GPFContributionDetail (EmpID, ContributionDate, Amount) VALUES ('" + EmpID + "', '" + ContributionDate + "' , '" + ContributionAmount + "'); select SCOPE_IDENTITY(); end");
            return(Fn.Exec("usp_GPFUpdateOpeningBalance '" + EmpID + "', '" + FromYear + "', '" + ToYear + "'"));
        }
Пример #9
0
        protected void AjaxFileUpload1_UploadComplete(object sender, AjaxControlToolkit.AjaxFileUploadEventArgs e)
        {
            string fname = DateTime.Now.ToString("yyyMMddHHmmss") + "." + e.FileName.Split('.')[1];

            Fn.Exec("INSERT INTO TblVoucherDoc(VoucherID, DocName, DocPath, DocExt)VALUES (" + Request.Cookies["VID"].Value + ", '" + e.FileName.Split('.')[0] + "', '" + fname + "', '" + e.FileName.Split('.')[1] + "')");
            string filePath = Server.MapPath("~") + "/Vouchers/" + fname;

            AjaxFileUpload1.SaveAs(filePath);
        }
Пример #10
0
        public string SchoolDetailedAssessment(string input)
        {
            string ret = "1";

            using (DBDataContext db = new DBDataContext())
            {
                SchoolDetailedAssessmentWebService obj = new SchoolDetailedAssessmentWebService();
                obj.input = input;
                db.SchoolDetailedAssessmentWebServices.InsertOnSubmit(obj);
                db.SubmitChanges();
            }
            //string[] inp = new string[116];
            string[] i = input.Split(new[] { "»»»" }, StringSplitOptions.None);
            foreach (string item in i)
            {
                string[] ii   = item.Split(new[] { "¡¡" }, StringSplitOptions.None);
                string[] inp  = ii[0].Split('½');
                string[] inp1 = ii[2].Split('½');
                string   tblAssesmentDetailedID = Fn.ExenID(@"INSERT INTO tblAssesmentDetailed
                         (TblUnionConcilID, tblSlumID, tblAssesmentRapidID, dtDate, dtStartTime, dtEndTime, Surveyor1, Surveyor1Contact, SchoolAddressLine1, NearestLandMark, PtclNumber, OtherContact, NameOfContact, CellPhone, 
                         email, GPS, SchoolOwnedBy, OwnersName, OwnersContactNo, PrincipalName, PrincipalBackground, RespondentsName, PositionRespondent, PositionRespondentOther, LowestClass, HighestClass, 
                         SchoolYearlyMonth, SchoolYealyEnd, ShiftOffered, dtStartTimeMorning, dtEndTimeMorning, dtStartTimeAfternoon, dtEndTimeAfternoon, QA10, QA11, IsTheSchoolRegistered, Sections, TypeOfSchool, 
                         TypeOfSchoolOther, LanguageCode, OtherLanguage, YearSchoolEstablished, YearSchoolRegistered, StudentArea1, StudentArea2, StudentArea3, UrduSpeeking, Other, Govt, Private, Slum1Near, Slum2Near, 
                         Slum3Near, EthnicUrdu, EthnicOther, PubOUP, PubOtherTxt, Attendance, AttendanceComputerized, TuitionFeeReceipt, TuitionFeeReceiptComputerized, TeachSalaries, TeacherSalariesComputerized, BankAccount,
                          AccountOnSchoolName, EFSPartned, ApplyRegistration, SchoolBuilding, SchoolBuildingOther, SizePlot1, SizePlot2, Floors1, Floors2, TotalRooms1, TotalRooms2, UnUsedRooms1Morning, 
                         UnUsedRooms2Morning, UnUsedRooms1Afternoon, UnUsedRooms2Afternoon, HallAvailable, HowMany, HallUsedClassRoom, Library, bookshelf, electricity, electricityAvailable, LoadShedding, generator, water, 
                         WaterDrinkable, Pitcher, BoundaryWall, TeachersToilets, TeachersToiletsFunctional, MaleStudentToilets, MaleStudentToiletsFunctional, FemaleStudentToilets, FemaleStudentToiletsFunctional, Playground, 
                         ComputerLab, NuberOfComputer, isBeingUsed, Transportation, NumberOfVans, ClassroomClean, CommonAreasClean, EatingAreaClean, CleanUniforms, NailsHairCut, DustbinAccessible, GarbageDeposit, Enroll, 
                         EnrollOlder,EnterByEmpID,dtEnterDateTime,QE13,QE14,QE15,QF2,QF1a_Class1,QF1b_Class1,QF1c_Class1,QF1a_Class3,QF1b_Class3,QF1c_Class3)
VALUES        ('" + inp[3] + @"','" + inp[4] + @"','" + inp[5] + @"','" + inp[6] + @"','" + inp[8] + @"','" + inp[9] + @"','" + inp[10] + @"','" + inp[11] + @"','" + inp[12] + @"','" + inp[13] + @"','" + inp[14] + @"','" + inp[15] + @"','" + inp[16] + @"','" + inp[17] + @"','" + inp[18] + @"','" + inp[19] + @"','" + inp[20] + @"','" + inp[21] + @"','" + inp[22] + @"','" + inp[23] + @"','" + inp[24] + @"','" + inp[25] + @"','" + inp[26] + @"','" + inp[27] + @"','" + inp[28] + @"','" + inp[29] + @"','" + inp[30] + @"','" + inp[31] + @"','" + inp[32] + @"','" + inp[33] + @"','" + inp[34] + @"','" + inp[35] + @"','" + inp[36] + @"','" + inp[37] + @"','" + inp[38] + @"','" + inp[39] + @"','" + inp[40] + @"','" + inp[41] + @"','" + inp[42] + @"','" + inp[43] + @"','" + inp[44] + @"','" + inp[45] + @"','" + inp[46] + @"','" + inp[47] + @"','" + inp[48] + @"','" + inp[49] + @"','" + inp[50] + @"','" + inp[51] + @"','" + inp[52] + @"','" + inp[53] + @"','" + inp[54] + @"','" + inp[55] + @"','" + inp[56] + @"','" + inp[57] + @"','" + inp[58] + @"','" + inp[59] + @"','" + inp[60] + @"','" + inp[61] + @"','" + inp[62] + @"','" + inp[63] + @"','" + inp[64] + @"','" + inp[65] + @"','" + inp[66] + @"','" + inp[67] + @"','" + inp[68] + @"','" + inp[69] + @"','" + inp[70] + @"','" + inp[71] + @"','" + inp[72] + @"','" + inp[73] + @"','" + inp[74] + @"','" + inp[75] + @"','" + inp[76] + @"','" + inp[77] + @"','" + inp[78] + @"','" + inp[79] + @"','" + inp[80] + @"','" + inp[81] + @"','" + inp[82] + @"','" + inp[83] + @"','" + inp[84] + @"','" + inp[85] + @"','" + inp[86] + @"','" + inp[87] + @"','" + inp[88] + @"','" + inp[89] + @"','" + inp[90] + @"','" + inp[91] + @"','" + inp[92] + @"','" + inp[93] + @"','" + inp[94] + @"','" + inp[95] + @"','" + inp[96] + @"','" + inp[97] + @"','" + inp[98] + @"','" + inp[99] + @"','" + inp[100] + @"','" + inp[101] + @"','" + inp[102] + @"','" + inp[103] + @"','" + inp[104] + @"','" + inp[105] + @"','" + inp[106] + @"','" + inp[107] + @"','" + inp[108] + @"','" + inp[109] + @"','" + inp[110] + @"','" + inp[111] + @"','" + inp[112] + @"','" + inp[113] + @"','" + inp[114] + @"','" + inp[115] + @"','" + inp[116] + @"','" + inp[0] + @"',GETDATE() , '" + inp1[0] + "' , '" + inp1[1] + "' , '" + inp1[2] + "' , '" + inp1[3] + "' , '" + inp1[4] + "' , '" + inp1[5] + "' , '" + inp1[6] + "' , '" + inp1[7] + "' , '" + inp1[8] + "' , '" + inp1[9] + "') ; select SCOPE_IDENTITY()  ");

                foreach (string tchr in ii[1].Split('¼'))
                {
                    string[] t = tchr.Split('½');
                    if (t.Length == 13)
                    {
                        Fn.Exec(@"INSERT INTO tblAssesmentDetailedTeacherInfo
                         (tblAssesmentDetailedID, E1_Name, E2_Type, E3_Age, E4_Gender, E5_Education, E6_YearAppointed, E7_Experience, E8_GradeTaught, E9_Is_Present, E10_If_No_Why, E11_Subject_Taught, E12_SalaryRange)
VALUES        ('" + tblAssesmentDetailedID + "','" + t[0] + "','" + t[1] + "','" + t[2] + "','" + t[3] + "','" + t[4] + "','" + t[5] + "','" + t[6] + "','" + t[7] + "','" + t[8] + "','" + t[9] + "','" + t[10] + "','" + t[12] + "')");
                    }
                }


                foreach (string tchr in ii[3].Split('¼'))
                {
                    string[] t = tchr.Split('½');
                    if (t.Length > 0)
                    {
                        Fn.Exec(@"INSERT INTO tblAssesmentDetailedClassInfo
                         (tblAssesmentDetailedID, Col1, Col2, Col3, Col4, Col5, Col6, Col7, Col8, Col9, Col10, Col11, Col12, Col13, Col14, Col15, Col16, Col18, Col19, Col21, Col22, Col23, Col24, Col25, Col26, Col27)
                          VALUES        ('" + tblAssesmentDetailedID + "', '" + t[0] + "', '" + t[1] + "', '" + t[2] + "', '" + t[3] + "', '" + t[4] + "', '" + t[5] + "', '" + t[6] + "', '" + t[7] + "', '" + t[8] + "', '" + t[9] + "', '" + t[10] + "', '" + t[11] + "', '" + t[12] + "', '" + t[13] + "', '" + t[14] + "', '" + t[15] + "', '" + t[16] + "', '" + t[17] + "', '" + t[18] + "', '" + t[19] + "', '" + t[20] + "', '" + t[21] + "', '" + t[22] + "', '" + t[23] + "', '" + t[24] + "')");
                    }
                }
            }



            return(ret);
        }
        public static string SaveAdvanceTitle(string AdvanceID, string Amount, string EmpID, string AdvanceDate)
        {
            string id = Fn.ExenID("INSERT INTO tbl_PayrollAdvanceDetail (AdvanceID, Amount, EmpID, AdvanceDate, Balance) VALUES ('" + AdvanceID + "','" + Amount + "','" + EmpID + "','" + AdvanceDate + "','" + Amount + "'); Select SCOPE_IDENTITY();");

            if (AdvanceID == "1002")
            {
                Fn.Exec("usp_PayrollGPFBalanceUpdate '" + EmpID + "', '" + (-1) * Convert.ToDecimal(Amount) + "', '" + AdvanceDate + "'");
            }

            return(id);
        }
Пример #12
0
        public void ProcessRequest(HttpContext context)
        {
            MyClass Fn = new MyClass();

            try
            {
                //var frmdata = context.Request.Form["vls"];

                var      frmdata = context.Request.Form["vls"];
                string[] d       = frmdata.Split('½');


                string id = d[0].Replace("_", "");
                id = id.Replace("#", "");
                id = id.Replace("imgprvw", "");


                if (context.Request.Files.Count > 0)
                {
                    HttpFileCollection SelectedFiles = context.Request.Files;

                    for (int i = 0; i < SelectedFiles.Count; i++)
                    {
                        HttpPostedFile PostedFile = SelectedFiles[i];
                        string         FileName   = context.Server.MapPath("~/Uploads/OrganizationDevelopment/" + PostedFile.FileName);
                        string         Path       = context.Server.MapPath("~/Uploads/OrganizationDevelopment/");
                        FileInfo       fi         = new FileInfo(FileName);
                        //int fileID = id;

                        Fn.Exec("UPDATE tblOD_Process SET  Procc = 'Uploads/OrganizationDevelopment/" + id + "" + fi.Extension + "' where ID = " + id);

                        PostedFile.SaveAs(Path + Convert.ToString(id) + fi.Extension);
                        context.Response.ContentType = "text/plain";
                        context.Response.Write("Activity Uploaded Successfully!");
                    }
                }
            }
            catch (Exception ex)
            {
                context.Response.ContentType = "text/plain";
                context.Response.Write(ex.Message);
            }
        }
        public void ProcessRequest(HttpContext context)
        {
            MyClass Fn = new MyClass();

            try
            {
                var      frmdata = context.Request.Form["vls"];
                string[] d       = frmdata.Split('½');
                string   Empid   = d[1];
                if (d[0] == "1")
                {
                    if (context.Request.Files.Count > 0)
                    {
                        HttpFileCollection SelectedFiles = context.Request.Files;

                        for (int i = 0; i < SelectedFiles.Count; i++)
                        {
                            HttpPostedFile PostedFile = SelectedFiles[i];
                            string         FileName   = context.Server.MapPath("~/Uploads/EmployeePhoto/" + PostedFile.FileName);
                            string         Path       = context.Server.MapPath("~/Uploads/EmployeePhoto/");
                            FileInfo       fi         = new FileInfo(FileName);

                            Fn.Exec("UPDATE TblHResources SET PhotoExtension = '" + fi.Extension + "' where User_ID = " + Empid);
                            PostedFile.SaveAs(Path + Convert.ToString(Empid) + fi.Extension);

                            if (fi.Extension.ToUpper() == ".JPEG" || fi.Extension.ToUpper() == ".JPG" || fi.Extension.ToUpper() == ".BMP" || fi.Extension.ToUpper() == ".PNG" || fi.Extension.ToUpper() == ".GIF")
                            {
                                Bitmap Thumbnail       = CreateThumbnail(Path + Convert.ToString(Empid) + fi.Extension, 32, 32);
                                string SaveAsThumbnail = System.IO.Path.Combine(context.Server.MapPath("~") + "/Uploads/EmployeePhoto/", Convert.ToString(Empid) + "A" + fi.Extension);
                                Thumbnail.Save(SaveAsThumbnail);
                            }

                            if (fi.Extension.ToUpper() == ".JPEG" || fi.Extension.ToUpper() == ".JPG" || fi.Extension.ToUpper() == ".BMP" || fi.Extension.ToUpper() == ".PNG" || fi.Extension.ToUpper() == ".GIF")
                            {
                                Bitmap Thumbnail       = CreateThumbnail(Path + Convert.ToString(Empid) + fi.Extension, 75, 75);
                                string SaveAsThumbnail = System.IO.Path.Combine(context.Server.MapPath("~") + "/Uploads/EmployeePhoto/", Convert.ToString(Empid) + "B" + fi.Extension);
                                Thumbnail.Save(SaveAsThumbnail);
                            }
                        }
                    }
                }

                if (d[0] == "2")
                {
                    if (context.Request.Files.Count > 0)
                    {
                        HttpFileCollection SelectedFiles = context.Request.Files;

                        for (int i = 0; i < SelectedFiles.Count; i++)
                        {
                            HttpPostedFile PostedFile = SelectedFiles[i];
                            string         FileName   = context.Server.MapPath("~/Uploads/EmployeeCV/" + PostedFile.FileName);
                            string         Path       = context.Server.MapPath("~/Uploads/EmployeeCV/");
                            FileInfo       fi         = new FileInfo(FileName);

                            Fn.Exec("UPDATE   TblHResources SET  CVExtension = '" + fi.Extension + "' WHERE (User_ID = '" + Empid + "')");
                            PostedFile.SaveAs(Path + Convert.ToString(Empid) + fi.Extension);
                        }
                    }
                }

                if (d[0] == "3")
                {
                    if (context.Request.Files.Count > 0)
                    {
                        HttpFileCollection SelectedFiles = context.Request.Files;

                        for (int i = 0; i < SelectedFiles.Count; i++)
                        {
                            HttpPostedFile PostedFile = SelectedFiles[i];
                            string         FileName   = context.Server.MapPath("~/Uploads/EmployeeDocs/" + PostedFile.FileName);
                            string         Path       = context.Server.MapPath("~/Uploads/EmployeeDocs/");
                            FileInfo       fi         = new FileInfo(FileName);

                            string NewID = Fn.ExenID("INSERT INTO tbl_EmployeeDocuments (FileName, FileExtension, EntryDate, EmpID) VALUES ('" + fi.Name + "', '" + fi.Extension + "' , GETDATE(), '" + Empid + "'); Select SCOPE_IDENTITY();");

                            PostedFile.SaveAs(Path + Convert.ToString(NewID) + fi.Extension);
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                context.Response.ContentType = "text/plain";
                context.Response.Write(ex.Message);
            }
        }
Пример #14
0
        public void ProcessRequest(HttpContext context)
        {
            try
            {
                var      frmdata = context.Request.Form["vls"];
                string[] d       = frmdata.Split('½');

                int benID = Convert.ToInt32(Convert.ToString(HttpContext.Current.Session["Emp_Id"]));

                HttpFileCollection SelectedFiles = context.Request.Files;
                if (SelectedFiles.Count > 0 && benID > 0)
                {
                    for (int i = 0; i < SelectedFiles.Count; i++)
                    {
                        HttpPostedFile PostedFile = SelectedFiles[i];
                        string         FileName   = context.Server.MapPath("~/Uploads/SchoolRapidPhoto/" + PostedFile.FileName);
                        string         Path       = context.Server.MapPath("~/Uploads/SchoolRapidPhoto/");
                        FileInfo       fi         = new FileInfo(FileName);
                        //decimal fileID = Convert.ToDecimal(d[0]);
                        string FileID = "0";
                        if (d[28] == "0")
                        {
                            FileID = Fn.ExenID(@"INSERT INTO tblAssesmentRapid
                         (strFormNo, dtSurveyDate, strSchoolName, strContactNoSchool, strSchoolEmail, strOwnerName, strOwnerContactNumber, strOwnerEmail, strPrincipalName, strPrincipalContactNumber, strPrincipalEmail,
                         strAddress1, strAddress2, strNearestLandMark, TblUnionConcilID, tblSlumID, strSchoolLatLang, strSurveyorName1, strSurveyorName2, dtStartDateTime, dtEndDateTime, Q1, Q2, Q3, Q4, Q5, Q6,
                         bisPictureAllowed, PicturePath, nEnterByEmpID, dtEntryDateTime)
                        VALUES('" + d[0] + "','" + d[1] + "','" + d[2] + "','" + d[3] + "','" + d[4] + "','" + d[5] + "','" + d[6] + "','" + d[7] + "','" + d[8] + "','" + d[9] + "','" + d[10] + "','" + d[11] + "','" + d[12] + "','" + d[13] + "','" + d[14] + "','" + d[15] + "','" + d[16] + "','" + d[17] + "','" + d[18] + "','" + d[19] + "','" + d[20] + "','" + d[21] + "','" + d[22] + "','" + d[23] + "','" + d[24] + "','" + d[25] + "','" + d[26] + "','" + d[27] + "','" + fi.Extension + "','" + Convert.ToString(benID) + "',GETDATE()); SELECT @@IDENTITY");
                        }
                        else
                        {
                            FileID = d[28];
                            Fn.Exec(@"UPDATE       tblAssesmentRapid
SET strFormNo ='" + d[0] + @"', 
dtSurveyDate ='" + d[1] + @"', 
strSchoolName ='" + d[2] + @"', 
strContactNoSchool ='" + d[3] + @"', 
strSchoolEmail ='" + d[4] + @"', 
strOwnerName ='" + d[5] + @"', 
strOwnerContactNumber ='" + d[6] + @"', 
strOwnerEmail ='" + d[7] + @"', 
strPrincipalName ='" + d[8] + @"', 
strPrincipalContactNumber ='" + d[9] + @"', 
strPrincipalEmail ='" + d[10] + @"', 
strAddress1 ='" + d[11] + @"', 
strAddress2 ='" + d[12] + @"', 
strNearestLandMark ='" + d[13] + @"', 
TblUnionConcilID ='" + d[14] + @"', 
tblSlumID ='" + d[15] + @"', 
strSchoolLatLang ='" + d[16] + @"', 
strSurveyorName1 ='" + d[17] + @"', 
strSurveyorName2 ='" + d[18] + @"', 
dtStartDateTime ='" + d[19] + @"', 
dtEndDateTime ='" + d[20] + @"', 
Q1 ='" + d[21] + @"', 
Q2 ='" + d[22] + @"', 
Q3 ='" + d[23] + @"', 
Q4 ='" + d[24] + @"', 
Q5 ='" + d[25] + @"', 
Q6 ='" + d[26] + @"', 
bisPictureAllowed ='" + d[27] + @"', 
PicturePath ='" + fi.Extension + @"'
WHERE        (tblAssesmentRapidID = '" + FileID + @"')");
                        }
                        PostedFile.SaveAs(Path + Convert.ToString(FileID) + fi.Extension);
                        if (fi.Extension.ToUpper() == ".JPEG" || fi.Extension.ToUpper() == ".JPG" || fi.Extension.ToUpper() == ".BMP" || fi.Extension.ToUpper() == ".PNG" || fi.Extension.ToUpper() == ".GIF")
                        {
                            Bitmap Thumbnail       = CreateThumbnail(Path + Convert.ToString(FileID) + fi.Extension, 32, 32);
                            string SaveAsThumbnail = System.IO.Path.Combine(context.Server.MapPath("~") + "/Uploads/SchoolRapidPhoto/", "A" + Convert.ToString(FileID) + fi.Extension);
                            Thumbnail.Save(SaveAsThumbnail);
                        }

                        if (fi.Extension.ToUpper() == ".JPEG" || fi.Extension.ToUpper() == ".JPG" || fi.Extension.ToUpper() == ".BMP" || fi.Extension.ToUpper() == ".PNG" || fi.Extension.ToUpper() == ".GIF")
                        {
                            Bitmap Thumbnail       = CreateThumbnail(Path + Convert.ToString(FileID) + fi.Extension, 75, 75);
                            string SaveAsThumbnail = System.IO.Path.Combine(context.Server.MapPath("~") + "/Uploads/SchoolRapidPhoto/", "B" + Convert.ToString(FileID) + fi.Extension);
                            Thumbnail.Save(SaveAsThumbnail);
                        }

                        context.Response.ContentType = "text/plain";
                        context.Response.Write("Record Saved");
                    }
                }

                else if (benID > 0)
                {
                    if (d[28] == "0")
                    {
                        Fn.Exec(@"INSERT INTO tblAssesmentRapid
                         (strFormNo, dtSurveyDate, strSchoolName, strContactNoSchool, strSchoolEmail, strOwnerName, strOwnerContactNumber, strOwnerEmail, strPrincipalName, strPrincipalContactNumber, strPrincipalEmail,
                         strAddress1, strAddress2, strNearestLandMark, TblUnionConcilID, tblSlumID, strSchoolLatLang, strSurveyorName1, strSurveyorName2, dtStartDateTime, dtEndDateTime, Q1, Q2, Q3, Q4, Q5, Q6,
                         bisPictureAllowed,  nEnterByEmpID, dtEntryDateTime)
                        VALUES('" + d[0] + "',CONVERT(DATETIME,'" + d[1] + "',103) ,'" + d[2] + "','" + d[3] + "','" + d[4] + "','" + d[5] + "','" + d[6] + "','" + d[7] + "','" + d[8] + "','" + d[9] + "','" + d[10] + "','" + d[11] + "','" + d[12] + "','" + d[13] + "','" + d[14] + "','" + d[15] + "','" + d[16] + "','" + d[17] + "','" + d[18] + "','" + d[19] + "','" + d[20] + "','" + d[21] + "','" + d[22] + "','" + d[23] + "','" + d[24] + "','" + d[25] + "','" + d[26] + "','" + d[27] + "','" + Convert.ToString(benID) + "',GETDATE())");
                    }
                    else
                    {
                        Fn.Exec(@"UPDATE       tblAssesmentRapid
SET strFormNo ='" + d[0] + @"', 
dtSurveyDate ='" + d[1] + @"', 
strSchoolName ='" + d[2] + @"', 
strContactNoSchool ='" + d[3] + @"', 
strSchoolEmail ='" + d[4] + @"', 
strOwnerName ='" + d[5] + @"', 
strOwnerContactNumber ='" + d[6] + @"', 
strOwnerEmail ='" + d[7] + @"', 
strPrincipalName ='" + d[8] + @"', 
strPrincipalContactNumber ='" + d[9] + @"', 
strPrincipalEmail ='" + d[10] + @"', 
strAddress1 ='" + d[11] + @"', 
strAddress2 ='" + d[12] + @"', 
strNearestLandMark ='" + d[13] + @"', 
TblUnionConcilID ='" + d[14] + @"', 
tblSlumID ='" + d[15] + @"', 
strSchoolLatLang ='" + d[16] + @"', 
strSurveyorName1 ='" + d[17] + @"', 
strSurveyorName2 ='" + d[18] + @"', 
dtStartDateTime ='" + d[19] + @"', 
dtEndDateTime ='" + d[20] + @"', 
Q1 ='" + d[21] + @"', 
Q2 ='" + d[22] + @"', 
Q3 ='" + d[23] + @"', 
Q4 ='" + d[24] + @"', 
Q5 ='" + d[25] + @"', 
Q6 ='" + d[26] + @"', 
bisPictureAllowed ='" + d[27] + @"'
WHERE        (tblAssesmentRapidID = '" + d[28] + @"')");
                    }

                    context.Response.ContentType = "text/plain";
                    context.Response.Write("Record Saved");
                }

                //context.Response.ContentType = "text/plain";
                //context.Response.Write("Files Uploaded Successfully!!");
            }
            catch (Exception ex)
            {
                context.Response.ContentType = "text/plain";
                context.Response.Write(ex.Message);
            }
        }
Пример #15
0
        public void ProcessRequest(HttpContext context)
        {
            MyClass Fn = new MyClass();

            string[] dataID = Fn.CleanSQL(HttpUtility.UrlDecode(context.Request.QueryString["id"])).Split('ǁ');
            string[] fdata  = new string[500];
            if (context.Request.Form["ourformData"] != null)
            {
                //string testing = context.Request.Form["ourformData"];
                fdata = HttpUtility.UrlDecode(context.Request.Form["ourformData"]).Split('½');
            }

            {
                try
                {
                    context.Response.ContentType = "text/HTML";
                    switch (Convert.ToInt32(dataID[0]))
                    {
                    case 0:
                        context.Response.Write(Fn.Data2Json("Select * from [dbo].[tblInventoryDefault] where tblInventoryDefaultID=1"));
                        break;

                    case 1:
                        context.Response.Write(Fn.Exec(@"UPDATE       tblInventoryDefault
SET                MaxLevels =" + dataID[1] + @"
WHERE        (tblInventoryDefaultID = 1)"));
                        break;


                    case 2:


//                            context.Response.Write(Fn.Data2Json(@"SELECT        tblPlaceID, Code, Name, Branch= (
//
//Select count(*) from tblPlace as B where B.ParentId= M.tblPlaceID
//)
//FROM            tblPlace AS M
//WHERE  ParentId IS NULL order by Code"));


                        context.Response.Write(Fn.Data2Json(@"Select M.CompanyID AS tblPlaceID, M.Code , M.CompanyName AS Name, 0 bIsHead, Branch= (
Select count(*) from tbl_Company AS B Where B.ParentId=M.CompanyID
) from tbl_Company as M WHERE  M.ParentId  IS NULL
order by M.CompanyID, M.Code"));


                        break;


                    case 3:

//                            context.Response.Write(Fn.Data2Json(@" SELECT        tblPlaceID, Code, Name, Branch= (
//
//Select count(*) from tblPlace as B where B.ParentId= M.tblPlaceID
//)
//FROM            tblPlace AS M
//WHERE  ParentId =" + dataID[1] + " order by Code"));



                        context.Response.Write(Fn.Data2Json(@" SELECT       M.CompanyID AS  tblPlaceID, Code, M.CompanyName Name, 0 bIsHead, Branch= (

Select count(*) from tbl_Company as B where B.ParentId= M.CompanyID
)
FROM            tbl_Company AS M
WHERE  ParentId =" + dataID[1] + " order by Code"));



                        break;

                    case 4:
//                            context.Response.Write(Fn.Exec(@"UPDATE       tblPlace
//SET                Name = '" + dataID[1] + @"'
//WHERE        (tblPlaceID = " + dataID[2] + ")"));


                        context.Response.Write(Fn.Exec(@"UPDATE       tbl_Company
SET                CompanyName = '" + dataID[1] + @"'
WHERE        (CompanyID = " + dataID[2] + ")"));
                        break;

                    case 5:
                        decimal?tblid   = 0;
                        int?    tblcode = 0;
                        using (DBDataContext db = new DBDataContext())
                        {
                            db.sp_tblPlace_Insert(dataID[1], dataID[2], ref tblid, ref tblcode);
                        }
                        string sssssss = Convert.ToString(tblid) + "½" + Convert.ToString(tblcode);
                        context.Response.Write(sssssss);
                        break;

                    default:
                        context.Response.Write("<p>Contents not available</p>");
                        break;
                    }
                }
                catch
                {
                    context.Response.ContentType = "text/HTML";
                    context.Response.Write("<p>Contents not available</p>");
                }
            }
        }
Пример #16
0
        public void ProcessRequest(HttpContext context)
        {
            MyClass Fn = new MyClass();

            try
            {
                var areaid  = context.Request.Form["areas"];
                var DSUS    = context.Request.Form["DSUS"];
                int Newcode = 0;
                using (DBDataContext db = new DBDataContext())
                {
                    try
                    {
                        Newcode  = db.tbl_Companies.Where(vv => vv.ParentId == Convert.ToDecimal(areaid)).Max(ss => ss.Code ?? 0);
                        Newcode += 1;
                    }
                    catch (Exception)
                    {
                        Newcode += 1;
                    }
                }
                var      frmdata = context.Request.Form["vls"];
                string[] d       = frmdata.Split('½');

                int CompanyID = 0;
                if (d[12] == "0")
                {
                    CompanyID = Convert.ToInt32(Fn.ExenID("INSERT INTO tbl_Company (CompanyName, CompanyAbbrivation, CompanyPhoneNo, CompanyEmail,  CompanyEstablishmentYear, CompanyWebsite, CompanyProvince, CompanyDistrictID, CompanyAddress, dtProjectFromDate, dtProjectToDate, GPS, code, ParentId, Type,lvl) VALUES        ('" + d[0] + "', '" + d[1] + "', '" + d[2] + "', '" + d[3] + "', '" + d[4] + "', '" + d[5] + "', '" + d[6] + "', '" + d[7] + "', '" + d[8] + "', CONVERT(DATETIME,'" + d[9] + @"',103),CONVERT(DATETIME,'" + d[10] + @"',103), '" + d[11] + "','" + Convert.ToString(Newcode) + "','" + areaid + "','Project','4'); select SCOPE_IDENTITY();"));
                    //using (DBDataContext db = new DBDataContext())
                    //{
                    //    List<TblHResourcesLocation> oblist = new List<TblHResourcesLocation>();
                    //    var emps = db.Logins.Where(v => v.User_Group_Id == 2).Select(s => s.Emp_Id).ToList<int>();
                    //    foreach (var emp in emps)
                    //    {
                    //        oblist.Add(new TblHResourcesLocation() { LocID = Convert.ToInt32(CompanyID), User_ID = emp });
                    //    }
                    //    db.TblHResourcesLocations.InsertAllOnSubmit(oblist);
                    //    db.SubmitChanges();
                    //}
                    var qry = "";
                    foreach (var item in DSUS.Split('½'))
                    {
                        if (item != "")
                        {
                            qry += "INSERT INTO tbl_CompanyProjectDSUs (tbl_CompanyDSUID, tbl_CompanyProjectID ) VALUES ('" + item + @"','" + CompanyID + @"'); ";
                        }
                    }
                    Fn.Exec(qry);
                }
                else
                {
                    CompanyID = Convert.ToInt32(d[12]);
                    Fn.Exec(@"UPDATE tbl_Company set
CompanyName= '" + d[0] + @"', 
CompanyAbbrivation= '" + d[1] + @"', 
CompanyPhoneNo= '" + d[2] + @"', 
CompanyEmail= '" + d[3] + @"', 
CompanyEstablishmentYear= '" + d[4] + @"', 
CompanyWebsite= '" + d[5] + @"', 
CompanyProvince= '" + d[6] + @"', 
CompanyDistrictID= '" + d[7] + @"', 
CompanyAddress= '" + d[8] + @"', 
dtProjectFromDate= CONVERT(DATETIME,'" + d[9] + @"',103), 
dtProjectToDate= CONVERT(DATETIME,'" + d[10] + @"',103), 
GPS= '" + d[11] + @"', 
ParentId= '" + areaid + @"', 
Type= 'Project',
lvl= '4'
WHERE CompanyID='" + d[12] + "'");


                    Fn.Exec("DELETE tbl_CompanyProjectDSUs WHERE tbl_CompanyProjectID='" + d[12] + @"'");
                    var qry = "";
                    foreach (var item in DSUS.Split('½'))
                    {
                        if (item != "")
                        {
                            qry += "INSERT INTO tbl_CompanyProjectDSUs (tbl_CompanyDSUID, tbl_CompanyProjectID ) VALUES ('" + item + @"','" + d[12] + @"'); ";
                        }
                    }
                    Fn.Exec(qry);
                }


                if (context.Request.Files.Count > 0 && CompanyID > 0)
                {
                    HttpFileCollection SelectedFiles = context.Request.Files;

                    for (int i = 0; i < SelectedFiles.Count; i++)
                    {
                        HttpPostedFile PostedFile = SelectedFiles[i];
                        string         FileName   = context.Server.MapPath("~/Uploads/CompanyProfile/" + PostedFile.FileName);
                        string         Path       = context.Server.MapPath("~/Uploads/CompanyProfile/");
                        FileInfo       fi         = new FileInfo(FileName);
                        //int fileID = 0;


                        Fn.Exec("update tbl_Company set CompanyLogo =  '" + fi.Extension + "' where CompanyID = " + Convert.ToString(CompanyID));
                        //PostedFile.SaveAs(Path + Convert.ToString(CompanyID) + fi.Extension);

                        PostedFile.SaveAs(Path + Convert.ToString(CompanyID) + fi.Extension);
                        if (fi.Extension.ToUpper() == ".JPEG" || fi.Extension.ToUpper() == ".JPG" || fi.Extension.ToUpper() == ".BMP" || fi.Extension.ToUpper() == ".PNG" || fi.Extension.ToUpper() == ".GIF")
                        {
                            Bitmap Thumbnail       = CreateThumbnail(Path + Convert.ToString(CompanyID) + fi.Extension, 32, 32);
                            string SaveAsThumbnail = System.IO.Path.Combine(context.Server.MapPath("~") + "/Uploads/CompanyProfile/", "A" + Convert.ToString(CompanyID) + fi.Extension);
                            Thumbnail.Save(SaveAsThumbnail);
                        }

                        if (fi.Extension.ToUpper() == ".JPEG" || fi.Extension.ToUpper() == ".JPG" || fi.Extension.ToUpper() == ".BMP" || fi.Extension.ToUpper() == ".PNG" || fi.Extension.ToUpper() == ".GIF")
                        {
                            Bitmap Thumbnail       = CreateThumbnail(Path + Convert.ToString(CompanyID) + fi.Extension, 75, 75);
                            string SaveAsThumbnail = System.IO.Path.Combine(context.Server.MapPath("~") + "/Uploads/CompanyProfile/", "B" + Convert.ToString(CompanyID) + fi.Extension);
                            Thumbnail.Save(SaveAsThumbnail);
                        }
                    }
                }

                if (CompanyID > 0)
                {
                    context.Response.ContentType = "text/plain";
                    context.Response.Write("Project Registered Successfully!");
                }
            }
            catch (Exception ex)
            {
                context.Response.ContentType = "text/plain";
                context.Response.Write(ex.Message);
            }
        }
Пример #17
0
        public void ProcessRequest(HttpContext context)
        {
            MyClass Fn = new MyClass();

            string[] dataID = Fn.CleanSQL(HttpUtility.UrlDecode(context.Request.QueryString["id"])).Split('ǁ');
            string[] fdata  = new string[500];
            if (context.Request.Form["ourformData"] != null)
            {
                //string testing = context.Request.Form["ourformData"];
                fdata = Fn.CleanSQL(HttpUtility.UrlDecode(context.Request.Form["ourformData"])).Split('½');
            }

            {
                try
                {
                    context.Response.ContentType = "text/HTML";
                    switch (Convert.ToInt32(dataID[0]))
                    {
                    case 0:
                        var x0   = context.Request.Form["frmData"];
                        var Id01 = HttpUtility.UrlDecode(Convert.ToString(x0));
                        if (Id01.Split('ǁ')[12] == "0")
                        {
                            context.Response.Write(Fn.ExenID(@"INSERT INTO tblJobRequirement
                         (Post, GradeBPS, PostJobStatus, DutyStation, TotalPositions, Gender, MinAge, MaxAge, Purpose, QualificationRequired, ExperienceRequired, JobDuties, dtDateTime, EnterByEmpID, Status)
VALUES        ('" + Id01.Split('ǁ')[0] + @"','" + Id01.Split('ǁ')[1] + @"','" + Id01.Split('ǁ')[2] + @"','" + Id01.Split('ǁ')[3] + @"','" + Id01.Split('ǁ')[4] + @"','" + Id01.Split('ǁ')[5] + @"','" + Id01.Split('ǁ')[6] + @"','" + Id01.Split('ǁ')[7] + @"','" + WebUtility.HtmlEncode(Id01.Split('ǁ')[8]) + @"','" + WebUtility.HtmlEncode(Id01.Split('ǁ')[9]) + @"','" + WebUtility.HtmlEncode(Id01.Split('ǁ')[10]) + @"','" + WebUtility.HtmlEncode(Id01.Split('ǁ')[11]) + @"',GETDATE(),'" + Convert.ToString(Convert.ToString(((HttpCookie)HttpContext.Current.Request.Cookies["Emp_Id"]).Value)) + @"','Sent'); select SCOPE_IDENTITY()"));
                        }
                        else
                        {
                            context.Response.Write(Fn.ExenID(@"UPDATE       tblJobRequirement
SET                Post ='" + Id01.Split('ǁ')[0] + @"', GradeBPS ='" + Id01.Split('ǁ')[1] + @"', PostJobStatus ='" + Id01.Split('ǁ')[2] + @"', DutyStation ='" + Id01.Split('ǁ')[3] + @"', TotalPositions ='" + Id01.Split('ǁ')[4] + @"', Gender ='" + Id01.Split('ǁ')[5] + @"', MinAge ='" + Id01.Split('ǁ')[6] + @"', MaxAge ='" + Id01.Split('ǁ')[7] + @"', Purpose ='" + WebUtility.HtmlEncode(Id01.Split('ǁ')[8]) + @"', QualificationRequired ='" + WebUtility.HtmlEncode(Id01.Split('ǁ')[9]) + @"', ExperienceRequired ='" + WebUtility.HtmlEncode(Id01.Split('ǁ')[10]) + @"', JobDuties ='" + WebUtility.HtmlEncode(Id01.Split('ǁ')[11]) + @"', Status ='Sent' ,Remarks =''
WHERE        (tblJobRequirementID = '" + Id01.Split('ǁ')[12] + @"'); select SCOPE_IDENTITY()"));
                        }

                        break;


                    case 1:
                        context.Response.Write(Fn.HTMLTableWithID_TR_Tag(@"SELECT        tblJobRequirementID, Post, PostJobStatus [Post JobS tatus], DutyStation [Duty Station], TotalPositions [Total Positions], Gender, MinAge [Min Age], MaxAge [Max Age], 
                         Status, Remarks
FROM            tblJobRequirement
order by dtDateTime", "tblReq"));
                        break;

                    case 2:
                        context.Response.Write(Fn.Data2Json(@"SELECT Post, GradeBPS, PostJobStatus, DutyStation, TotalPositions, Gender, MinAge, MaxAge, Purpose, QualificationRequired, ExperienceRequired, JobDuties, tblJobRequirementID FROM tblJobRequirement WHERE tblJobRequirementID=" + dataID[1]));
                        break;


                    case 3:
                        context.Response.Write(Fn.HTMLTableWithID_TR_Tag(@"SELECT        tblJobRequirementID, Post, GradeBPS [Grade/BPS], PostJobStatus [Post JobS tatus], DutyStation [Duty Station], TotalPositions [Total Positions], Gender, MinAge [Min Age], MaxAge [Max Age], 
                         Status
FROM            tblJobRequirement
 where status = 'Sent'
 order by dtDateTime", "tblReq"));
                        break;

                    case 4:
                        var x4   = context.Request.Form["frmData"];
                        var Id41 = HttpUtility.UrlDecode(Convert.ToString(x4));
                        if (Id41.Split('ǁ')[12] == "0")
                        {
                            context.Response.Write(Fn.ExenID(@"INSERT INTO tblJobRequirement
                         (Post, GradeBPS, PostJobStatus, DutyStation, TotalPositions, Gender, MinAge, MaxAge, Purpose, QualificationRequired, ExperienceRequired, JobDuties, dtDateTime, EnterByEmpID, Status)
VALUES        ('" + Id41.Split('ǁ')[0] + @"','" + Id41.Split('ǁ')[1] + @"','" + Id41.Split('ǁ')[2] + @"','" + Id41.Split('ǁ')[3] + @"','" + Id41.Split('ǁ')[4] + @"','" + Id41.Split('ǁ')[5] + @"','" + Id41.Split('ǁ')[6] + @"','" + Id41.Split('ǁ')[7] + @"','" + WebUtility.HtmlEncode(Id41.Split('ǁ')[8]) + @"','" + WebUtility.HtmlEncode(Id41.Split('ǁ')[9]) + @"','" + WebUtility.HtmlEncode(Id41.Split('ǁ')[10]) + @"','" + WebUtility.HtmlEncode(Id41.Split('ǁ')[11]) + @"',GETDATE(),'" + Convert.ToString(Convert.ToString(((HttpCookie)HttpContext.Current.Request.Cookies["Emp_Id"]).Value)) + @"','Sent'); select SCOPE_IDENTITY()"));
                        }
                        else
                        {
                            context.Response.Write(Fn.ExenID(@"UPDATE       tblJobRequirement
SET                Post ='" + Id41.Split('ǁ')[0] + @"', GradeBPS ='" + Id41.Split('ǁ')[1] + @"', PostJobStatus ='" + Id41.Split('ǁ')[2] + @"', DutyStation ='" + Id41.Split('ǁ')[3] + @"', TotalPositions ='" + Id41.Split('ǁ')[4] + @"', Gender ='" + Id41.Split('ǁ')[5] + @"', MinAge ='" + Id41.Split('ǁ')[6] + @"', MaxAge ='" + Id41.Split('ǁ')[7] + @"', Purpose ='" + WebUtility.HtmlEncode(Id41.Split('ǁ')[8]) + @"', QualificationRequired ='" + WebUtility.HtmlEncode(Id41.Split('ǁ')[9]) + @"', ExperienceRequired ='" + WebUtility.HtmlEncode(Id41.Split('ǁ')[10]) + @"', JobDuties ='" + WebUtility.HtmlEncode(Id41.Split('ǁ')[11]) + @"'
,  Remarks ='" + WebUtility.HtmlEncode(Id41.Split('ǁ')[14]) + @"' ,  LastDateToApply=CONVERT(DATETIME,'" + WebUtility.HtmlEncode(Id41.Split('ǁ')[15]) + @"',103),  Status='" + WebUtility.HtmlEncode(Id41.Split('ǁ')[16]) + @"'
WHERE        (tblJobRequirementID = '" + Id41.Split('ǁ')[12] + @"'); select SCOPE_IDENTITY()"));
                        }

                        break;

                    case 5:
                        context.Response.Write(Fn.HTMLTableWithID_TR_Tag(@"Select tblJobRequirementID,  'FRDP-B4-'+RIGHT('00000' + CAST(tblJobRequirementID AS VARCHAR(50)),5) +'/'+CAST(DATEPART(YYYY, dtDateTime) AS VARCHAR(50))+'-R' AS [Case No], Post, GradeBPS [Grade/BPS], PostJobStatus [Job Status], DutyStation [Duty Station], TotalPositions [Total Positions] , convert(varchar(50), CONVERT(DATETIME,ISNULL(LastDateToApply,'01/01/1990'),103), 106) as [Last Date] from tblJobRequirement 
where LastDateToApply > GetDATE() order by dtDateTime desc", "tblJl"));
                        break;
                    //Select tblJobRequirementID,  'PPHI-B4-'+RIGHT('00000' + CAST(tblJobRequirementID AS VARCHAR(50)),5) +'/'+CAST(DATEPART(YYYY, dtDateTime) AS VARCHAR(50))+'-R' AS [Case No] from tblJobRequirement

                    case 6:
                        context.Response.Write(Fn.Data2Json(@"SELECT        tblJobRequirementID, 'FRDP-B4-' + RIGHT('00000' + CAST(tblJobRequirementID AS VARCHAR(50)), 5) + '/' + CAST(DATEPART(YYYY, dtDateTime) AS VARCHAR(50)) + '-R' +' [ '+ Post +' ]' as Post
FROM            tblJobRequirement
ORDER BY dtDateTime DESCs"));
                        break;

                    case 7:
                        context.Response.Write(Fn.HTMLTableWithID_TR_Tag(@"SELECT        tblCandidate_tblJobRequirement.tblCandidate_tblJobRequirementID, tblCandidate.Name, tblCandidate.FatherName [Father Name], Convert(varchar(50),tblCandidate.dtDOB,103) as [DOB], tblCandidate.CNIC, tblCandidate.City, tblCandidate.District, 
                         tblCandidate.Phone, tblCandidate.Mobile, CONVERT(varchar(50), tblCandidate_tblJobRequirement.dtDateTime, 103) AS [Date Applied], Case When tblCandidate_tblJobRequirement.bIsShortListed=1 Then '<button  title=''Select Candidate...'' class=''btnEdit btn btn-success'' customtooltip=''Select Candidate''>s</button>' else '<button  title=''Select Candidate...'' class=''btnEdit btn btn-info'' customtooltip=''Select Candidate''>s</button>' END as [ ]
FROM            tblCandidate_tblJobRequirement INNER JOIN
                         tblCandidate ON tblCandidate_tblJobRequirement.tblCandidateID = tblCandidate.tblCandidateID
WHERE tblCandidate_tblJobRequirement.tblJobRequirementID =" + dataID[1], "tblJl"));
                        break;

                    case 8:
                        context.Response.Write(Fn.Exec("UPDATE tblCandidate_tblJobRequirement SET bIsShortListed=" + dataID[2] + " WHERE tblCandidate_tblJobRequirementID='" + dataID[1] + "'"));
                        break;


                    case 9:
                        context.Response.Write(Fn.HTMLTableWithID_TR_Tag(@"SELECT        tblCandidate_tblJobRequirement.tblCandidate_tblJobRequirementID, tblCandidate.Name, tblCandidate.FatherName AS [Father Name], CONVERT(varchar(50), tblCandidate.dtDOB, 103) AS DOB, tblCandidate.CNIC, 
                         tblCandidate.City, tblCandidate.District, tblCandidate.Phone, tblCandidate.Mobile, CONVERT(varchar(50), tblCandidate_tblJobRequirement.dtDateTime, 103) AS [Date Applied], 
                         '<input class=''btnEdit Integer'' type=''text''  value='''+CAST(ISNULL(tblCandidate_tblJobRequirement.InterviewMarks,'0') AS VARCHAR(50))+'''  style=''width: 60px;''>' AS [Interview Marks]
FROM            tblCandidate_tblJobRequirement INNER JOIN
                         tblCandidate ON tblCandidate_tblJobRequirement.tblCandidateID = tblCandidate.tblCandidateID
WHERE tblCandidate_tblJobRequirement.bIsShortListed = 1 and tblCandidate_tblJobRequirement.tblJobRequirementID =" + dataID[1], "tblJl"));
                        break;

                    case 10:
                        context.Response.Write(Fn.Exec("UPDATE tblCandidate_tblJobRequirement SET InterviewMarks='" + dataID[2] + "' WHERE tblCandidate_tblJobRequirementID='" + dataID[1] + "'"));
                        break;

                    case 11:
                        context.Response.Write(Fn.HTMLTableWithID_TR_Tag(@"SELECT        tblCandidate_tblJobRequirement.tblCandidate_tblJobRequirementID, tblCandidate.Name, tblCandidate.FatherName AS [Father Name], CONVERT(varchar(50), tblCandidate.dtDOB, 103) AS DOB, tblCandidate.CNIC, 
                         tblCandidate.City, tblCandidate.District, tblCandidate.Phone, tblCandidate.Mobile, CONVERT(varchar(50), tblCandidate_tblJobRequirement.dtDateTime, 103) AS [Date Applied], 
                         ISNULL(tblCandidate_tblJobRequirement.InterviewMarks,0) AS [Interview Marks]
FROM            tblCandidate_tblJobRequirement INNER JOIN
                         tblCandidate ON tblCandidate_tblJobRequirement.tblCandidateID = tblCandidate.tblCandidateID
WHERE tblCandidate_tblJobRequirement.bIsShortListed = 1 and tblCandidate_tblJobRequirement.tblJobRequirementID =" + dataID[1] + " ORDER BY ISNULL(tblCandidate_tblJobRequirement.InterviewMarks,0) ", "tblJl"));
                        break;

                    case 12:
                        context.Response.Write(Fn.HTMLTableWithID_TR_Tag(@"SELECT        Login.LoginID,'' [Sr#], Login.UserName, tblDtl.Name, tblDtl.[Emp No], tblDtl.[Service Type], tblDtl.Father, tblDtl.CNIC, tblDtl.BPS, tblDtl.Designation, User_Groups.User_Group_Name [Group Name]
FROM            Login INNER JOIN
                             (SELECT        User_ID, Full_Name AS Name, '' AS [Emp No], '' AS [Service Type], FatherName AS Father, CNIC, '' AS BPS, Designation, 'TblHResources' AS TableName
                               FROM            TblHResources
                               UNION
                               SELECT        tblEmployee.EmpID, ISNULL(tblEmployee.FName, '') + ' ' + ISNULL(tblEmployee.LName, '') AS Name, 'FRDP-EMP-' + RIGHT('00000' + CAST(ISNULL(tblEmployee.EmpNo, 0) AS VARCHAR(50)), 5) 
                                                        AS EMPNO, tblEmployee.PostTyp, ISNULL(tblEmployee.Father, '') AS Father, tblEmployee.CNIC, CASE WHEN tblEmployee.BPS = 0 THEN 'N/A' ELSE 'BPS' + CAST(tblEmployee.BPS AS VARCHAR(50))
                                                         END AS BPS, tblDesig.NAME AS Designation, 'tblEmployee' AS TableName
                               FROM            tbl_Company INNER JOIN
                                                        tblDept INNER JOIN
                                                        Shift INNER JOIN
                                                        tblEmployee INNER JOIN
                                                        TblDistrict ON tblEmployee.Domicile = TblDistrict.DistrictID ON Shift.Shift_ID = tblEmployee.tblEmpShiftID INNER JOIN
                                                        tblDesig ON tblEmployee.tblDesigID = tblDesig.ID ON tblDept.ID = tblEmployee.tblDept ON tbl_Company.CompanyID = tblEmployee.tblCompanyID) AS tblDtl ON Login.Emp_Id = tblDtl.User_ID AND 
                         Login.TableName = tblDtl.TableName INNER JOIN
                         User_Groups ON Login.User_Group_Id = User_Groups.User_Group_Id
order by  Login.UserName", "tblJl"));
                        break;

                    default:
                        context.Response.Write("<p>Contents not available</p>");
                        break;
                    }
                }
                catch
                {
                    context.Response.ContentType = "text/HTML";
                    context.Response.Write("<p>Contents not available</p>");
                }
            }
        }
        public static string SaveBasicData(string vals, string loc)
        {
            string[] d = vals.Split('½');
            string[] l = loc.Split('½');
            if (d[17] == "0")
            {
                DataSet ds = Fn.FillDSet(@"SELECT 
'FRDP-EMP-' +RIGHT('0000' + CAST(MAX(EmpNo) + 1 AS VARCHAR(50)) ,3) 
AS EmpNo 
,  CAST(MAX(EmpNo) + 1 AS VARCHAR(50))  EC
FROM (
SELECT CAST(EmpNo AS INT) EmpNo FROM [dbo].[TblHResources] WHERE EmpNo IS NOT NULL
) AS X");

                DataTable dttt   = ds.Tables[0];
                string    eno    = Convert.ToString(dttt.Rows[0][0]);
                string    en     = Convert.ToString(dttt.Rows[0][1]);
                string    UserID = Fn.ExenID("INSERT INTO TblHResources (EmpNo, CNIC, Full_Name, FatherName, DOB, Is_Male, CompanyID, DeptID, DesignationID, UserGroupID, ContactNos, U_Status, Qualification, Email, AppointmentDate, ResignationDate, Address, EnteryDate) VALUES ('" + en + "','" + d[1] + "','" + d[2] + "','" + d[3] + "','" + d[4] + "','" + d[5] + "','" + d[6] + "','" + d[7] + "','" + d[8] + "','" + d[9] + "','" + d[10] + "','" + d[11] + "','" + d[12] + "','" + d[13] + "','" + d[14] + "','" + d[15] + "','" + d[16] + "', Getdate());  Select Scope_Identity();");


                Fn.Exec("DELETE FROM TblHResourcesLocations WHERE UserID=" + UserID);

                foreach (var item in l)
                {
                    Fn.Exec(@"INSERT INTO TblHResourcesLocations
                         (User_ID, LocID)
                    VALUES (" + UserID + "," + item + ")");
                }

                Fn.Exec(@"UPDATE       TblHResources
                SET                U_Pass ='******' where User_ID=" + UserID);
                Fn.Exec(@"INSERT INTO Login
                         (UserName, Password, Created_Date, User_Group_Id, Emp_Id, Login_Status, IP_Check)
                VALUES        ('" + eno + "' ,'" + Encryptor.Encrypt(eno) + "', GETDATE(),'" + d[9] + "','" + UserID + "', 1, 0)");

                return(UserID);
            }
            else
            {
                Fn.Exec("UPDATE TblHResources SET CNIC = '" + d[1] + "', Full_Name = '" + d[2] + "', FatherName = '" + d[3] + "', DOB = '" + d[4] + "', Is_Male = '" + d[5] + "', CompanyID = '" + d[6] + "', DeptID = '" + d[7] + "', DesignationID = '" + d[8] + "', UserGroupID = '" + d[9] + "', ContactNos = '" + d[10] + "', U_Status = '" + d[11] + "', Qualification = '" + d[12] + "', Email = '" + d[13] + "', AppointmentDate = '" + d[14] + "', ResignationDate = '" + d[15] + "', Address = '" + d[16] + "' where User_ID = '" + d[17] + "';  Select Scope_Identity();");

                Fn.Exec(@"UPDATE Login
                         SET User_Group_Id='" + d[9] + "' WHERE Emp_Id =" + d[17]);



                Fn.Exec("DELETE FROM TblHResourcesLocations WHERE User_ID=" + d[17]);
                List <TblHResourcesLocation> el = new List <TblHResourcesLocation>();
                foreach (var item in l)
                {
                    //   Fn.Exec(@"INSERT INTO TblHResourcesLocations (User_ID, LocID) VALUES (" + d[17] + "," + item + ")");
                    if (item != "")
                    {
                        el.Add(new TblHResourcesLocation()
                        {
                            LocID = Convert.ToInt32(item), User_ID = Convert.ToInt32(d[17])
                        });
                    }
                }
                if (l.Length > 0)
                {
                    using (DBDataContext db = new DBDataContext())
                    {
                        db.TblHResourcesLocations.InsertAllOnSubmit(el);
                        db.SubmitChanges();
                    }
                }


                return(d[17]);
            }
        }
Пример #19
0
        public static string MakeRequisition(string h, string i, string con, string thisid)
        {
            string ret = "";
            JavaScriptSerializer jss = new JavaScriptSerializer();
            var head = jss.Deserialize <Dictionary <string, dynamic> >(h);

            if (thisid == "0")
            {
                dynamic ai = JObject.Parse(i);
                decimal?tblInvReqMainID = 0;
                string  tblInvReqNo     = "";
                using (DBDataContext db = new DBDataContext())
                {
                    db.sp_tblInvReqPurchaseMain_Insert(Convert.ToInt32(Convert.ToString(Convert.ToString(((HttpCookie)HttpContext.Current.Request.Cookies["Emp_Id"]).Value))), Convert.ToInt32(con), Convert.ToDecimal(head["Head"]["StoreID"]), Convert.ToString(head["Head"]["StoreName"]), Convert.ToString(head["Head"]["Subject"]), Convert.ToString(head["Head"]["Description"]), ref tblInvReqMainID, ref tblInvReqNo);
                    List <tblInvReqSub> l = new List <tblInvReqSub>();
                    foreach (var item in ai.Items)
                    {
                        var          f = item;
                        tblInvReqSub o = new tblInvReqSub();
                        o.ItemName        = item.ItemName;
                        o.Quality         = item.Quality;
                        o.Quantity        = item.Quantity;
                        o.tblInvReqMainID = tblInvReqMainID;
                        o.temID           = item.ItemID;
                        o.Unit            = item.Unit;
                        l.Add(o);
                    }
                    db.tblInvReqSubs.InsertAllOnSubmit(l);
                    db.SubmitChanges();
                }
                ret = Convert.ToString(tblInvReqMainID) + "½" + tblInvReqNo;
            }
            else
            {
                MyClass Fn = new MyClass();
                Fn.Exec("delete [dbo].[tblInvReqSub] where tblInvReqMainID=" + thisid.Split('½')[0]);
                Fn.Exec(@"UPDATE       tblInvReqMain
                        SET                Status ='" + con + @"', ToStoreID ='" + Convert.ToString(head["Head"]["StoreID"]) + @"', StoreName ='" + Convert.ToString(head["Head"]["StoreName"]) + @"', Subject ='" + Convert.ToString(head["Head"]["Subject"]) + @"', Description ='" + Convert.ToString(head["Head"]["Description"]) + @"'
                        WHERE        (tblInvReqMainID = " + thisid.Split('½')[0] + @" )");
                using (DBDataContext db = new DBDataContext())
                {
                    dynamic             ai = JObject.Parse(i);
                    List <tblInvReqSub> l  = new List <tblInvReqSub>();
                    foreach (var item in ai.Items)
                    {
                        var          f = item;
                        tblInvReqSub o = new tblInvReqSub();
                        o.ItemName        = item.ItemName;
                        o.Quality         = item.Quality;
                        o.Quantity        = item.Quantity;
                        o.tblInvReqMainID = Convert.ToDecimal(thisid.Split('½')[0]);
                        o.temID           = item.ItemID;
                        o.Unit            = item.Unit;
                        l.Add(o);
                    }
                    db.tblInvReqSubs.InsertAllOnSubmit(l);
                    db.SubmitChanges();
                }
                ret = thisid;
            }
            return(ret);
        }
Пример #20
0
 public static string SaveData(string EmpId, string PensionMonth, string PensionYear, string Bank, string MonthlyPension, string MedicalAllowance, string Arrears, string Deductions, string NetPaid, string Remarks)
 {
     return(Fn.Exec("usp_PensionMonthlyTransfer '" + EmpId + "' ,'" + PensionMonth + "','" + PensionYear + "','" + Bank + "','" + MonthlyPension + "','" + MedicalAllowance + "','" + Arrears + "','" + Deductions + "','" + NetPaid + "','" + Remarks + "'      "));
 }
Пример #21
0
        public void ProcessRequest(HttpContext context)
        {
            try
            {
                var      frmdata  = context.Request.Form["vls"];
                var      Province = context.Request.Form["Province"];
                string[] d        = frmdata.Split('½');

                int benID = 0;

                using (DBDataContext db = new DBDataContext())
                {
                    if (db.TblHResources.Where(v => v.ContactNos == d[2]).Count() == 0)
                    {
                        TblHResource obj = new TblHResource();
                        obj.Full_Name   = d[1];
                        obj.ContactNos  = d[2];
                        obj.UserGroupID = Convert.ToInt32(d[4]);
                        obj.Email       = d[5];
                        obj.U_Pass      = Encryptor.Encrypt(d[6].Replace("'", ""));
                        obj.EnteryDate  = DateTime.Now;
                        obj.U_Status    = true;
                        obj.U_ThemeID   = 1;
                        obj.Designation = d[3];


                        db.TblHResources.InsertOnSubmit(obj);
                        db.SubmitChanges();
                        benID = obj.User_ID;


                        //new Thread(() =>
                        //{
                        QR objQR = new QR();
                        objQR.QrGenerate(Convert.ToString(benID), "TblHResources", Convert.ToString(benID));
                        //string result = LongRunningMethod("World");
                        //Dispatcher.BeginInvoke((Action)();
                        //}).Start();



                        string[] l = Province.Split('½');
                        Fn.ExenID(@"INSERT INTO Login
                         (UserName, Password, Created_Date, User_Group_Id, Emp_Id, Login_Status, IP_Check)
                            VALUES        ('" + d[2] + "' ,'" + Encryptor.Encrypt(d[6]) + "', GETDATE(),'" + d[4] + "','" + benID + "', 1, 0)");

                        foreach (var item in l)
                        {
                            Fn.Exec(@"INSERT INTO TblHResourcesLocations
                         (User_ID, LocID)
                    VALUES (" + benID + "," + item + ")");
                        }
                    }
                    else
                    {
                        context.Response.ContentType = "text/plain";
                        context.Response.Write("Record Already Exists");
                    }
                }


                if (context.Request.Files.Count > 0 && benID > 0)
                {
                    HttpFileCollection SelectedFiles = context.Request.Files;

                    for (int i = 0; i < SelectedFiles.Count; i++)
                    {
                        HttpPostedFile PostedFile = SelectedFiles[i];
                        string         FileName   = context.Server.MapPath("~/Uploads/EmployeePhoto/" + PostedFile.FileName);
                        string         Path       = context.Server.MapPath("~/Uploads/EmployeePhoto/");
                        FileInfo       fi         = new FileInfo(FileName);
                        int            fileID     = benID;

                        using (DBDataContext db = new DBDataContext())
                        {
                            var o = db.TblHResources.Where(v => v.User_ID == fileID).FirstOrDefault();
                            if (o != null)
                            {
                                o.PhotoExtension = fi.Extension;
                                o.DisplayName    = fi.Extension;
                                db.SubmitChanges();
                            }
                        }
                        PostedFile.SaveAs(Path + Convert.ToString(fileID) + fi.Extension);
                        if (fi.Extension.ToUpper() == ".JPEG" || fi.Extension.ToUpper() == ".JPG" || fi.Extension.ToUpper() == ".BMP" || fi.Extension.ToUpper() == ".PNG" || fi.Extension.ToUpper() == ".GIF")
                        {
                            Bitmap Thumbnail       = CreateThumbnail(Path + Convert.ToString(fileID) + fi.Extension, 32, 32);
                            string SaveAsThumbnail = System.IO.Path.Combine(context.Server.MapPath("~") + "/Uploads/EmployeePhoto/", Convert.ToString(fileID) + "A" + fi.Extension);
                            Thumbnail.Save(SaveAsThumbnail);
                        }

                        if (fi.Extension.ToUpper() == ".JPEG" || fi.Extension.ToUpper() == ".JPG" || fi.Extension.ToUpper() == ".BMP" || fi.Extension.ToUpper() == ".PNG" || fi.Extension.ToUpper() == ".GIF")
                        {
                            Bitmap Thumbnail       = CreateThumbnail(Path + Convert.ToString(fileID) + fi.Extension, 75, 75);
                            string SaveAsThumbnail = System.IO.Path.Combine(context.Server.MapPath("~") + "/Uploads/EmployeePhoto/", Convert.ToString(fileID) + "B" + fi.Extension);
                            Thumbnail.Save(SaveAsThumbnail);
                        }



                        //using (DBDataContext db =  new DBDataContext())
                        //{
                        //    db.sp_RegisterEmpWithLogin(d[0], d[1], "", "", "", d[2], d[5], "", d[3], 1, 1, DateTime.Now, Encryptor.Encrypt(d[6].Replace("'", "")), Convert.ToInt32(d[4]), Convert.ToString(benID)+"."+ fi.Extension);
                        //}



                        context.Response.ContentType = "text/plain";
                        context.Response.Write("Record Saved");
                    }
                }

                else if (benID > 0)
                {
                    //using (DBDataContext db = new DBDataContext())
                    //{
                    //    db.sp_RegisterEmpWithLogin(d[0], d[1], "", "", "", d[2], d[5], "", d[3], 1, 1, DateTime.Now, Encryptor.Encrypt(d[6].Replace("'", "")), Convert.ToInt32(d[4]), null);
                    //}
                    context.Response.ContentType = "text/plain";
                    context.Response.Write("Record Saved");
                }

                //context.Response.ContentType = "text/plain";
                //context.Response.Write("Files Uploaded Successfully!!");
            }
            catch (Exception ex)
            {
                context.Response.ContentType = "text/plain";
                context.Response.Write(ex.Message);
            }
        }
Пример #22
0
        public static String AddLoc(String Loc, string Latude, string Path, string TypeID, string ParentID, string Population)
        {
            //  string myret = Fn.Exec("insert into " + getTblName(TypeID) + " (LocName,Lat,Path," + getTblName(TypeID).ToUpper().Replace("TBL", "") + "ID) values('" + Loc + "','" + Latude + "','" + Path + "'," + ParentID + ")");
            // return myret;
            ///8888888888888888888888888888888888888888888888888TypeID

            switch (TypeID)
            {
            case "1":
                // return "tblCountry";
                using (DBDataContext db = new DBDataContext())
                {
                    if (db.TblCountries.Where(v => v.LocName.ToUpper().Trim() == Loc.ToUpper().Trim()).Count() > 0)
                    {
                        return("-1");
                    }

                    else
                    {
                        TblCountry tbl = new TblCountry();
                        tbl.LocName   = Loc;
                        tbl.Latitude  = Latude;
                        tbl.Path      = Path;
                        tbl.Lat       = Latude;
                        tbl.Longitude = Latude;
                        db.TblCountries.InsertOnSubmit(tbl);
                        db.SubmitChanges();
                        return("1");
                    }
                }

            case "2":
                //return "TblProvince";
                using (DBDataContext db = new DBDataContext())
                {
                    if (db.TblProvinces.Where(v => v.LocName.ToUpper().Trim() == Loc.ToUpper().Trim() && v.CountryID == Convert.ToInt32(ParentID)).Count() > 0)
                    {
                        return("-1");
                    }
                }

                return(Fn.Exec("insert into " + getTblName(TypeID) + " (LocName,Lat,Path," + getTblName(Convert.ToString(Convert.ToInt32(TypeID) - 1)).ToUpper().Replace("TBL", "") + "ID) values('" + Loc + "','" + Latude + "','" + Path + "'," + ParentID + ")"));

            case "3":
                //return "TblRegion";
                using (DBDataContext db = new DBDataContext())
                {
                    if (db.TblRegions.Where(v => v.LocName.ToUpper().Trim() == Loc.ToUpper().Trim() && v.ProvinceID == Convert.ToInt32(ParentID)).Count() > 0)
                    {
                        return("-1");
                    }
                }
                return(Fn.Exec("insert into " + getTblName(TypeID) + " (LocName,Lat,Path," + getTblName(Convert.ToString(Convert.ToInt32(TypeID) - 1)).ToUpper().Replace("TBL", "") + "ID) values('" + Loc + "','" + Latude + "','" + Path + "'," + ParentID + ")"));

            case "4":
                // return "TblDistrict";
                using (DBDataContext db = new DBDataContext())
                {
                    if (db.TblDistricts.Where(v => v.LocName.ToUpper().Trim() == Loc.ToUpper().Trim()).Count() > 0)
                    {
                        return("-1");
                    }
                }
                return(Fn.Exec("insert into " + getTblName(TypeID) + " (LocName,Lat,Path," + getTblName(Convert.ToString(Convert.ToInt32(TypeID) - 1)).ToUpper().Replace("TBL", "") + "ID) values('" + Loc + "','" + Latude + "','" + Path + "'," + ParentID + ")"));

            case "5":
                // return "TblTehsil";

                using (DBDataContext db = new DBDataContext())
                {
                    if (db.TblTehsils.Where(v => v.LocName.ToUpper().Trim() == Loc.ToUpper().Trim() && v.DistrictID == Convert.ToInt32(ParentID)).Count() > 0)
                    {
                        return("-1");
                    }
                }
                return(Fn.Exec("insert into " + getTblName(TypeID) + " (LocName,Lat,Path," + getTblName(Convert.ToString(Convert.ToInt32(TypeID) - 1)).ToUpper().Replace("TBL", "") + "ID) values('" + Loc + "','" + Latude + "','" + Path + "'," + ParentID + ")"));

            case "6":
                // return "TblFeildUnit";
                using (DBDataContext db = new DBDataContext())
                {
                    if (db.TblFeildUnits.Where(v => v.LocName.ToUpper().Trim() == Loc.ToUpper().Trim() && v.TehsilID == Convert.ToInt32(ParentID)).Count() > 0)
                    {
                        return("-1");
                    }
                }
                return(Fn.Exec("insert into " + getTblName(TypeID) + " (LocName,Lat,Path," + getTblName(Convert.ToString(Convert.ToInt32(TypeID) - 1)).ToUpper().Replace("TBL", "") + "ID) values('" + Loc + "','" + Latude + "','" + Path + "'," + ParentID + ")"));

            case "7":
                // return "TblUnionConcil";
                using (DBDataContext db = new DBDataContext())
                {
                    if (db.TblUnionConcils.Where(v => v.LocName.ToUpper().Trim() == Loc.ToUpper().Trim() && v.FeildUnitID == Convert.ToInt32(ParentID)).Count() > 0)
                    {
                        return("-1");
                    }
                }
                return(Fn.Exec("insert into " + getTblName(TypeID) + " (LocName,Lat,Path," + getTblName(Convert.ToString(Convert.ToInt32(TypeID) - 1)).ToUpper().Replace("TBL", "") + "ID) values('" + Loc + "','" + Latude + "','" + Path + "'," + ParentID + ")"));

            case "8":
                //                    return "TblVillageCity";
                using (DBDataContext db = new DBDataContext())
                {
                    if (db.TblVillageCities.Where(v => v.LocName.ToUpper().Trim() == Loc.ToUpper().Trim() && v.UnionConcilID == Convert.ToInt32(ParentID)).Count() > 0)
                    {
                        return("-1");
                    }
                }
                return(Fn.Exec("insert into " + getTblName(TypeID) + " (LocName,Lat,Path,Population," + getTblName(Convert.ToString(Convert.ToInt32(TypeID) - 1)).ToUpper().Replace("TBL", "") + "ID) values('" + Loc + "','" + Latude + "','" + Path + "'," + Population + "," + ParentID + ")"));

            default:
                return("");
            }


            //var loca = db.s.Where(v => v.LocName.ToUpper() == Loc.ToUpper() && v.TypeID == Convert.ToInt32(TypeID)).FirstOrDefault();
            //if (loca != null)
            //{
            //    return "-1";
            //}
            //else
            //{
            //    return Fn.Exec("insert into  (LocName,Lat,Path,TypeID,ParentID) values('" + Loc + "','" + Latude + "','" + Path + "','" + TypeID + "'," + ParentID + ")");


            //}

            //}

            //return "";
        }
Пример #23
0
        public void ProcessRequest(HttpContext context)
        {
            MyClass Fn = new MyClass();

            string[] dataID = Fn.CleanSQL(HttpUtility.UrlDecode(context.Request.QueryString["id"])).Split('ǁ');

            {
                try
                {
                    context.Response.ContentType = "text/HTML";
                    switch (Convert.ToInt32(dataID[0]))
                    {
                    case 0:
                        using (DBDataContext db = new DBDataContext())
                        {
                            if (db.tblElecticityMeters.Where(vv => vv.MeterNo.ToUpper() == dataID[4].ToUpper()).Count() > 0)
                            {
                                context.Response.Write("Meter No Already Registered");
                                break;
                            }
                        }
                        if (dataID[2] == "WAPDA In")
                        {
                            context.Response.Write(Fn.Exec(@"INSERT INTO dbo.tblElecticityMeter
                            (tbl_Company_LocationID, MeterType,     MeterPlacedAt, MeterNo, MeterReading, OwnerName, OwnerType, Emp_Id, dtDateTime, MultipleFactor)
                            VALUES        ('" + dataID[1] + "','" + dataID[2] + "','" + dataID[3] + "','" + dataID[4] + "','" + dataID[5] + "','" + dataID[6] + "','" + dataID[7] + "','" + Convert.ToString(Convert.ToString(((HttpCookie)HttpContext.Current.Request.Cookies["Emp_Id"]).Value)) + "',GETDATE() , '" + dataID[8] + "')"));
                        }
                        else if (dataID[2] == "Main Meter")
                        {
                            context.Response.Write(Fn.Exec(@"INSERT INTO dbo.tblElecticityMeter
                         (tbl_Company_LocationID, MeterType, WapdaMeterID,  MeterPlacedAt, MeterNo, MeterReading, OwnerName, OwnerType, Emp_Id, dtDateTime, MultipleFactor)
                         VALUES        ('" + dataID[1] + "','" + dataID[2] + "','" + dataID[3] + "','" + dataID[4] + "','" + dataID[5] + "','" + dataID[6] + "','" + dataID[7] + "','" + dataID[8] + "','" + Convert.ToString(Convert.ToString(((HttpCookie)HttpContext.Current.Request.Cookies["Emp_Id"]).Value)) + "',GETDATE() , '" + dataID[9] + "')"));
                        }
                        else if (dataID[2] == "Sub Meter")
                        {
                            context.Response.Write(Fn.Exec(@"INSERT INTO dbo.tblElecticityMeter
                         (tbl_Company_LocationID, MeterType, WapdaMeterID, MainMeterID, MeterPlacedAt, MeterNo, MeterReading, OwnerName, OwnerType, Emp_Id, dtDateTime, MultipleFactor)
                         VALUES        ('" + dataID[1] + "','" + dataID[2] + "','" + dataID[3] + "','" + dataID[4] + "','" + dataID[5] + "','" + dataID[6] + "','" + dataID[7] + "','" + dataID[8] + "','" + dataID[9] + "','" + Convert.ToString(Convert.ToString(((HttpCookie)HttpContext.Current.Request.Cookies["Emp_Id"]).Value)) + "',GETDATE() , '" + dataID[10] + "')"));
                        }
                        break;


                    case 1:
                        context.Response.Write(Fn.Data2Json(@"SELECT  tblElecticityMeter.MeterNo,      tblElecticityMeter.tblElecticityMeterID, tblElecticityMeter.MeterType, tblElecticityMeter.OwnerName, tblElecticityMeter.tbl_Company_LocationID, tblElecticityMeter.MeterReading, tblElecticityMeter.Emp_Id, 
                         tblElecticityMeter.dtDateTime, tbl_Company.CompanyName
FROM            tblElecticityMeter INNER JOIN
                         tbl_Company ON tblElecticityMeter.tbl_Company_LocationID = tbl_Company.CompanyID"));
                        break;

                    case 2:
                        context.Response.Write(Fn.Exec(@"DELETE FROM tblElecticityMeter
WHERE        tblElecticityMeterID = " + dataID[1]));
                        break;

                    case 3:
                        context.Response.Write(Fn.Data2Json(@"SELECT  tblElecticityMeter.MeterNo,      tblElecticityMeter.tblElecticityMeterID, tblElecticityMeter.MeterType, tblElecticityMeter.OwnerName, tblElecticityMeter.tbl_Company_LocationID, tblElecticityMeter.MeterReading, tblElecticityMeter.Emp_Id, 
                         tblElecticityMeter.dtDateTime, tbl_Company.CompanyName
FROM            tblElecticityMeter INNER JOIN
                         tbl_Company ON tblElecticityMeter.tbl_Company_LocationID = tbl_Company.CompanyID where tblElecticityMeter.tblElecticityMeterID =" + dataID[1]));
                        break;


                    case 4:
                        context.Response.Write(Fn.Exec(@"UPDATE       tblElecticityMeter
                            SET                MeterNo ='" + dataID[1] + "', MeterType ='" + dataID[2] + "', OwnerName ='" + dataID[3] + "', tbl_Company_LocationID ='" + dataID[4] + "', MeterReading ='" + dataID[5] + "' WHERE tblElecticityMeterID=" + dataID[6]));
                        break;


                    case 5:
                        context.Response.Write(Fn.Data2Json(@"SELECT        tblElecticityMeterID, MeterNo
FROM            tblElecticityMeter
WHERE        (tbl_Company_LocationID =" + dataID[1] + ") ORDER BY MeterNo"));
                        break;

                    case 6:
                        string[] d6  = dataID[3].Split('-');
                        DateTime dt6 = new DateTime(Convert.ToInt32(d6[2]), Convert.ToInt32(d6[1]), Convert.ToInt32(d6[0]));
                        context.Response.Write(Fn.Exec(@"INSERT INTO tblElecticityMeterReading
                         (tblElecticityMeterID, dtDate, reading, OffPeakReading, OnPeakReading)
                        VALUES        ('" + dataID[2] + "','" + dt6 + "','" + dataID[4] + "', '" + dataID[5] + "', '" + dataID[6] + "')"));
                        break;

                    case 7:
                        context.Response.Write(Fn.Data2Json(@"SELECT        tblElecticityMeterReading.tblElecticityMeterReadingID, CONVERT(VARCHAR(50),tblElecticityMeterReading.dtDate,103) AS dtDate, tblElecticityMeterReading.reading, tblElecticityMeterReading.tblElecticityMeterID, tblElecticityMeter.MeterNo
FROM            tblElecticityMeterReading INNER JOIN
                         tblElecticityMeter ON tblElecticityMeterReading.tblElecticityMeterID = tblElecticityMeter.tblElecticityMeterID ORDER BY tblElecticityMeterReading.dtDate , tblElecticityMeter.MeterNo
"));
                        break;


                    case 8:
                        context.Response.Write(Fn.Exec(@"DELETE FROM tblElecticityMeterReading
WHERE        tblElecticityMeterReadingID = " + dataID[1]));
                        break;

                    //////////////////////////////////////////
                    case 9:
                        context.Response.Write(Fn.Data2Json(@"SELECT        tblGeneratorMaintinanceID, CONVERT(VARCHAR(50), dtDateTime, 103) AS dtDateTime, MeterReading, HoursValue,Parts, Description, tblGeneratorID
FROM            tblGeneratorMaintinance
WHERE tblGeneratorID=" + dataID[1] + "ORDER BY dtDateTime"));
                        break;

                    case 10:
                        string[] d10  = dataID[1].Split('-');
                        DateTime dt10 = new DateTime(Convert.ToInt32(d10[2]), Convert.ToInt32(d10[1]), Convert.ToInt32(d10[0]));

                        context.Response.Write(Fn.Exec(@"INSERT INTO tblGeneratorOnOff
                         (dtDate, DipVlue, MeterReading, OnTime, OffTime, Description, tblGeneratorID)
VALUES        ('" + dt10 + "','" + dataID[5] + "','" + dataID[4] + "','" + d10[2] + '-' + d10[1] + '-' + d10[0] + ' ' + dataID[2] + "','" + d10[2] + '-' + d10[1] + '-' + d10[0] + ' ' + dataID[3] + "','" + dataID[6] + "', " + dataID[7] + ")"));
                        break;


                    case 11:
                        context.Response.Write(Fn.Data2Json(@"SELECT        tblGeneratorID AS ID, ISNULL(Modal,'') +' '+ ISNULL(Brand,'') AS Modal
FROM            tblGenerator
WHERE        LocationID =" + dataID[1]));
                        break;

                    case 12:
                        context.Response.Write(Fn.Data2Json(@"SELECT tblGenerator.tblGeneratorID, tblGenerator.LocationID, tblGenerator.EnterbyEmp, tblGenerator.dtEnteredDate, tblGenerator.Modal, tblGenerator.Brand, tblGenerator.Capacity, tblGenerator.FuleTankSize, 
                         tblGenerator.FuleFilterModal, tblGenerator.OilFilterModal, tblGenerator.WaterFilterModal, tblGenerator.AirFilterModal, tblGenerator.OilQuantity, tblGenerator.coolentQuantity, tblGenerator.ServiceDurationHours, 
                         tblGenerator.MinFuleLevelLiter, tblGenerator.CurrentMeterReading, tblGenerator.GeneratorLifeHours, tbl_Company.CompanyName AS LocationName
FROM            tblGenerator INNER JOIN
                         tbl_Company ON tblGenerator.LocationID = tbl_Company.CompanyID where tblGenerator.tblGeneratorID=" + dataID[1]));
                        break;


                    case 13:
                        context.Response.Write(Fn.Data2Json(@"Select tblElecticityMeterID , MeterNo  from tblElecticityMeter where tbl_Company_LocationID='" + dataID[1] + "' AND MeterType='WAPDA In'"));
                        break;

                    case 14:
                        context.Response.Write(Fn.Data2Json(@"Select tblElecticityMeterID , MeterNo  from tblElecticityMeter where tbl_Company_LocationID='" + dataID[1] + "' AND WapdaMeterID='" + dataID[2] + "' AND MeterType='Main Meter'"));
                        break;

                    case 15:
                        context.Response.Write(Fn.Data2Json(@"Select Distinct MeterPlacedAt  from tblElecticityMeter Where MeterPlacedAt is not NULL AND tbl_Company_LocationID=" + dataID[1]));
                        break;

                    case 16:
                        context.Response.Write(Fn.Data2Json(@"Select Distinct OwnerName  from tblElecticityMeter Where OwnerName is not NULL AND tbl_Company_LocationID=" + dataID[1]));
                        break;

                    case 17:
                        context.Response.Write(Fn.Data2Json(@"SELECT        tblElecticityMeterReading.tblElecticityMeterReadingID, CONVERT(VARCHAR(50), tblElecticityMeterReading.dtDate, 103) AS dtDate, tblElecticityMeterReading.reading, tblElecticityMeterReading.tblElecticityMeterID,
                          tblElecticityMeter.MeterNo, ISNULL(tblElecticityMeterReading.OffPeakReading, '0') AS OffPeakReading, ISNULL(tblElecticityMeterReading.OnPeakReading, '0') AS OnPeakReading
FROM            tblElecticityMeterReading INNER JOIN
                         tblElecticityMeter ON tblElecticityMeterReading.tblElecticityMeterID = tblElecticityMeter.tblElecticityMeterID
WHERE        (tblElecticityMeterReading.tblElecticityMeterID = " + dataID[1] + @") and  (DATEPART(MM,tblElecticityMeterReading.dtDate) = " + dataID[2].Split('-')[1] + @") AND (DATEPART(YYYY,tblElecticityMeterReading.dtDate) = " + dataID[2].Split('-')[2] + @")  ORDER BY tblElecticityMeterReading.dtDate , tblElecticityMeter.MeterNo"));
                        break;

                    case 18:
                        context.Response.Write(Fn.Data2Json(@"SELECT        tblElecticityMeter.MeterNo, tblElecticityMeter.tblElecticityMeterID, tblElecticityMeter.MeterType, tblElecticityMeter.OwnerName, tblElecticityMeter.tbl_Company_LocationID, tblElecticityMeter.MeterReading, 
                         tblElecticityMeter.Emp_Id, tblElecticityMeter.dtDateTime, tbl_Company.CompanyName
FROM            tblElecticityMeter INNER JOIN
                         tbl_Company ON tblElecticityMeter.tbl_Company_LocationID = tbl_Company.CompanyID
WHERE        tblElecticityMeter.tbl_Company_LocationID = " + dataID[1]));
                        break;

                    //                        case 13:
                    //context.Response.Write(Fn.Data2Json(@""));
                    //break;

                    //                        case 13:
                    //context.Response.Write(Fn.Data2Json(@""));
                    //break;
                    default:
                        context.Response.Write("<p>Contents not available</p>");
                        break;
                    }
                }
                catch
                {
                    context.Response.ContentType = "text/HTML";
                    context.Response.Write("<p>Contents not available</p>");
                }
            }
        }
Пример #24
0
        protected void btnLogin_Click(object sender, EventArgs e)
        {
            if (ValidateControls())
            {
                try
                {
                    string    ssssssssssss = Encryptor.Encrypt(txtPass.Text);
                    DataTable DT           = Fn.FillDSet("sp_Login '" + txtUser.Text + "','" + Encryptor.Encrypt(txtPass.Text) + "'").Tables[0];

                    if (txtPass.Text == Encryptor.Decrypt(DT.Rows[0]["Password"].ToString()))
                    {
                        //string EN = "";
                        //int? EID = 0, UGID = 0;
                        //bool? IsAllowed = false;
                        //using (DBDataContext db = new DBDataContext())
                        //{
                        //    db.User_Login(txtUser.Text, ssssssssssss, ref EN, ref EID, ref UGID, "", ref IsAllowed);
                        //}
                        //if (Convert.ToBoolean(IsAllowed) && Convert.ToInt32(EID) > 0)
                        //{

                        Session.Add("EmpName", Convert.ToString(DT.Rows[0]["EmpName"]));
                        Response.Cookies["EmpName"].Value   = Convert.ToString(DT.Rows[0]["EmpName"]);
                        Response.Cookies["EmpName"].Expires = DateTime.Now.AddDays(1);

                        Session.Add("bIsEmployee", Convert.ToString(DT.Rows[0]["bIsEmployee"]));
                        Response.Cookies["bIsEmployee"].Value   = Convert.ToString(DT.Rows[0]["bIsEmployee"]);
                        Response.Cookies["bIsEmployee"].Expires = DateTime.Now.AddDays(1);


                        Session.Add("Emp_Id", Convert.ToString(DT.Rows[0]["Emp_Id"]));
                        Response.Cookies["Emp_Id"].Value   = Convert.ToString(DT.Rows[0]["Emp_Id"]);
                        Response.Cookies["Emp_Id"].Expires = DateTime.Now.AddDays(1);
                        //READ Cookie in c#
                        //Convert.ToString(HttpContext.Current.Session["Emp_Id"]);

                        Session.Add("User_Group_ID", Convert.ToString(DT.Rows[0]["User_Group_ID"]));
                        Response.Cookies["User_Group_ID"].Value   = Convert.ToString(DT.Rows[0]["User_Group_ID"]);
                        Response.Cookies["User_Group_ID"].Expires = DateTime.Now.AddDays(1);


                        Session.Add("UserID", Convert.ToString(DT.Rows[0]["UserID"]));
                        Response.Cookies["UserID"].Value   = Convert.ToString(DT.Rows[0]["UserID"]);
                        Response.Cookies["UserID"].Expires = DateTime.Now.AddDays(1);


                        Session.Add("username", Convert.ToString(DT.Rows[0]["UserName"]));
                        Response.Cookies["username"].Value   = Convert.ToString(DT.Rows[0]["UserName"]);
                        Response.Cookies["username"].Expires = DateTime.Now.AddDays(1);


                        Session.Add("onlyname", Convert.ToString(DT.Rows[0]["onlyname"]));
                        Response.Cookies["onlyname"].Value   = Convert.ToString(DT.Rows[0]["onlyname"]);
                        Response.Cookies["onlyname"].Expires = DateTime.Now.AddDays(1);


                        Session.Add("GroupID", Convert.ToString(DT.Rows[0]["GroupID"]));
                        Response.Cookies["GroupID"].Value   = Convert.ToString(DT.Rows[0]["GroupID"]);
                        Response.Cookies["GroupID"].Expires = DateTime.Now.AddDays(1);


                        //Session.Add("PRD", DT.Rows[0][5]);
                        Session.Add("ContactNo", Convert.ToString(DT.Rows[0]["ContactNo"]));
                        Response.Cookies["ContactNo"].Value   = Convert.ToString(DT.Rows[0]["ContactNo"]);
                        Response.Cookies["ContactNo"].Expires = DateTime.Now.AddDays(1);

                        Session.Add("email", Convert.ToString(DT.Rows[0]["Email"]));
                        Response.Cookies["email"].Value   = Convert.ToString(DT.Rows[0]["Email"]);
                        Response.Cookies["email"].Expires = DateTime.Now.AddDays(1);

                        Session.Add("designation", Convert.ToString(DT.Rows[0]["designation"]));
                        Response.Cookies["designation"].Value   = Convert.ToString(DT.Rows[0]["designation"]);
                        Response.Cookies["designation"].Expires = DateTime.Now.AddDays(1);



                        Session.Add("picExt", Convert.ToString(DT.Rows[0]["picExt"]));
                        Response.Cookies["picExt"].Value   = Convert.ToString(DT.Rows[0]["picExt"]);
                        Response.Cookies["picExt"].Expires = DateTime.Now.AddDays(1);

                        Session.Add("CompanyID", Convert.ToString(DT.Rows[0]["CompanyID"]));
                        Response.Cookies["CompanyID"].Value   = Convert.ToString(DT.Rows[0]["CompanyID"]);
                        Response.Cookies["CompanyID"].Expires = DateTime.Now.AddDays(1);


                        //Response.Cookies["theme"].Value = DT.Rows[0][3].ToString();
                        //Response.Cookies["theme"].Expires = DateTime.Now.AddDays(1);



                        //Response.Cookies["PRD"].Value = HttpUtility.UrlEncode(DT.Rows[0][5].ToString());
                        //Response.Cookies["PRD"].Expires = DateTime.Now.AddDays(1);



                        Response.Cookies["FirstRun"].Value   = "1";
                        Response.Cookies["FirstRun"].Expires = DateTime.Now.AddDays(1);


                        string S = Fn.ExenID("select TOP(1) Format(AMonth, 'MM')+Format(AMonth, 'yyy') AMonth from tblMonthCloseing");
                        Session.Add("Amonth", S);


                        Session.Add("OfficeId", 16);
                        Response.Cookies["OfficeId"].Value   = "16";
                        Response.Cookies["OfficeId"].Expires = DateTime.Now.AddDays(1);
                        //
                        string[] info = Fn.GetRecords("SELECT AccYear, AccYear2, CodeSt, AMonth, AcYrID FROM tblSetup WHERE (CompID = 16)");
                        Session.Add("ActYr", Fn.FirstDayOfMonthFromDateTime(Convert.ToDateTime(info[0])));
                        Response.Cookies["ActYr"].Value   = Convert.ToString(Fn.FirstDayOfMonthFromDateTime(Convert.ToDateTime(info[0])));
                        Response.Cookies["ActYr"].Expires = DateTime.Now.AddDays(1);

                        Session.Add("ActYr2", Fn.LastDayOfMonthFromDateTime(Convert.ToDateTime(info[1])));
                        Response.Cookies["ActYr2"].Value   = Convert.ToString(Fn.LastDayOfMonthFromDateTime(Convert.ToDateTime(info[1])));
                        Response.Cookies["ActYr2"].Expires = DateTime.Now.AddDays(1);

                        Session.Add("ActMth", Convert.ToDateTime(info[3]).ToString("MMMM yyyy"));
                        Response.Cookies["ActMth"].Value   = Convert.ToString(Convert.ToDateTime(info[3]).ToString("MMMM yyyy"));
                        Response.Cookies["ActMth"].Expires = DateTime.Now.AddDays(1);

                        Session.Add("CodeSt", info[2]);
                        Response.Cookies["CodeSt"].Value   = Convert.ToString(info[2]);
                        Response.Cookies["CodeSt"].Expires = DateTime.Now.AddDays(1);

                        Session.Add("br", "16");
                        Response.Cookies["br"].Value   = "16";
                        Response.Cookies["br"].Expires = DateTime.Now.AddDays(1);

                        Session.Add("fy", Convert.ToString(info[4]));
                        Response.Cookies["fy"].Value   = Convert.ToString(info[4]);
                        Response.Cookies["fy"].Expires = DateTime.Now.AddDays(1);

                        //$.cookie('fy', $('#ddYear').val());
                        //$.cookie('ey', $('#ddey').val());

                        string S1 = Fn.ExenID("select TOP(1) Format(AMonth, 'MM')+Format(AMonth, 'yyy') AMonth from tblMonthCloseing");
                        //Session.Add("ActMth", S1);
                        Session.Add("OfficeId", 16);

                        Fn.Exec("INSERT INTO tblUserLog(UserID) VALUES (" + Convert.ToString(DT.Rows[0]["UserID"]) + ")");
                        Response.Cookies["xx"].Value   = S;
                        Response.Cookies["xx"].Expires = DateTime.Now.AddDays(1);
                        Response.Cookies["yy"].Value   = "16";
                        Response.Cookies["yy"].Expires = DateTime.Now.AddDays(1);
                        Response.Redirect(DT.Rows[0]["MP"].ToString());
                        //}
                    }
                    else
                    {
                        lblMsg.Text    = "The username or password you entered is incorrect.";
                        lblMsg.Visible = true;
                    }
                }
                catch (Exception ex)
                {
                    lblMsg.Text    = "The username or password you entered is incorrect...";
                    lblMsg.Visible = true;
                }
            }
        }