Esempio n. 1
0
      public bool Update()
      {
          DbAccess db = new DbAccess();

          SqlParameter[] prams ={            
                db.CreateInParam("@CID",SqlDbType.Int,4,CID),
                db.CreateInParam("@CName",SqlDbType.VarChar,50,CName),
               db.CreateInParam("@Desc",SqlDbType.VarChar,20,Desc),
                
            };
          db.ExecuteStoredProcedure("Class_Update", ref prams);
          return true;
      }
Esempio n. 2
0
      public bool Update(string names,string cont,string dycont,string phone,string email,string add)
      {
          DbAccess db = new DbAccess();

          SqlParameter[] prams ={                
               
              db.CreateInParam("@Name",SqlDbType.VarChar,100,names),
               db.CreateInParam("@Controller",SqlDbType.VarChar,50,cont),
               db.CreateInParam("@DyController",SqlDbType.VarChar,200,dycont),
               db.CreateInParam("@Phone",SqlDbType.VarChar,200,phone),
               db.CreateInParam("@Email",SqlDbType.VarChar,200,email),
               db.CreateInParam("@Address",SqlDbType.VarChar,200,add),
               
            };
          db.ExecuteStoredProcedure("Org_Update", ref prams);
          return true;
      }
Esempio n. 3
0
      public bool Update()
      {
          DbAccess db = new DbAccess();

          SqlParameter[] prams ={            
      db.CreateInParam("@UID",SqlDbType.Int,4,UserID),
              db.CreateInParam("@UserName",SqlDbType.VarChar,50,UserName),
               db.CreateInParam("@Password",SqlDbType.VarChar,20,Password),
                db.CreateInParam("@RoleID",SqlDbType.Int,4,RoleID),
                 db.CreateInParam("@Section",SqlDbType.VarChar,30,Department),
                   db.CreateInParam("@Designation",SqlDbType.VarChar,30,Designation),
                     db.CreateInParam("@CNIC",SqlDbType.VarChar,15,CNIC),
               
            };
          db.ExecuteStoredProcedure("User_Update", ref prams);
          return true;
      }
Esempio n. 4
0
        public bool Insert() 
        {

            DbAccess db = new DbAccess();
            SqlParameter[] prams ={ 
               db.CreateInParam("@AdmNo",SqlDbType.Int,4,AdmNo),
               db.CreateInParam("@AdmDate",SqlDbType.Date,8,AdmDate),
               db.CreateInParam("@SName",SqlDbType.VarChar,50,SName ),
               db.CreateInParam("@DOB",SqlDbType.Date,8,DOB),
               db.CreateInParam("@Nationality",SqlDbType.VarChar,30,Nationality),
               db.CreateInParam("@ClassID",SqlDbType.Int,4,ClassID),
                   db.CreateInParam("@Section",SqlDbType.VarChar,10,Section),
               db.CreateInParam("@PrevSchool",SqlDbType.VarChar,300,PrevSchool),
               db.CreateInParam("@Address",SqlDbType.VarChar,300,Address),
               db.CreateInParam("@Phone",SqlDbType.VarChar,30,Phone),
               db.CreateInParam("@FName",SqlDbType.VarChar,50,FName),
               db.CreateInParam("@FMobile",SqlDbType.VarChar,30,FMobile),
               db.CreateInParam("@MName",SqlDbType.VarChar,50,MName),
               db.CreateInParam("@MMobile",SqlDbType.VarChar,30,MMobile),
               db.CreateInParam("@Guardian",SqlDbType.VarChar,50,Guardian),
               db.CreateInParam("@FGAddress",SqlDbType.VarChar,300,FGAddress),
               db.CreateInParam("@WPhone",SqlDbType.VarChar,30,WPhone),
               db.CreateInParam("@Email",SqlDbType.VarChar,30,Email),
               db.CreateInParam("@Scholarship",SqlDbType.VarChar,10,Scholarship),
               db.CreateInParam("@AdmStatus",SqlDbType.VarChar,100,AdmStatus),
               db.CreateInParam("@Remarks",SqlDbType.VarChar,300,Remarks),

               db.CreateInParam("@PIC",SqlDbType.Image,PIC.Length,PIC),

                                 };
            db.ExecuteStoredProcedure("Student_Insert", ref prams);

            return true;
        }
Esempio n. 5
0
     public bool SetCanceled(int sfid,int admno,int payed,int tot,string status,int parrs)
     {

         DbAccess db = new DbAccess();
         SqlParameter[] prams ={ 
               db.CreateInParam("@SFID",SqlDbType.Int,4,sfid),
                db.CreateInParam("@AdmNo",SqlDbType.Int,4,admno),
                 db.CreateInParam("@Payed",SqlDbType.Int,4,payed),
                 db.CreateInParam("@Total",SqlDbType.Int,4,tot),
                 db.CreateInParam("@PrevArrears",SqlDbType.Int,4,parrs),
                    db.CreateInParam("@Status",SqlDbType.VarChar,30,status),
              // db.CreateInParam("@RecptNo",SqlDbType.VarChar,20,RecptNo),
 
                                 };
         db.ExecuteStoredProcedure("SetCanceled", ref prams);

         return true;
     }
Esempio n. 6
0
     public bool UpdateArrears()
     {
         DbAccess db = new DbAccess();

         SqlParameter[] prams ={     
               
              
               db.CreateInParam("@AdmNo",SqlDbType.Int,4,AdmNo),
             
               db.CreateInParam("@Arrears",SqlDbType.Int,4,CurrArrears),
                         };
         db.ExecuteStoredProcedure("ArrearsUpdate", ref prams);
         return true;
     }
Esempio n. 7
0
     public bool Update()
     {
         DbAccess db = new DbAccess();

         SqlParameter[] prams ={     
               
               db.CreateInParam("@SFID",SqlDbType.Int,4,SFID),

               db.CreateInParam("@SID",SqlDbType.Int,4,SID),
               db.CreateInParam("@AdmNo",SqlDbType.Int,4,AdmNo),
               db.CreateInParam("@ClassID",SqlDbType.Int,4,ClassID),
               db.CreateInParam("@RecptNo",SqlDbType.VarChar,20,RecptNo),
               db.CreateInParam("@Year",SqlDbType.VarChar,10,Year ),
               db.CreateInParam("@Month",SqlDbType.VarChar,10,Month),
               db.CreateInParam("@RegFee",SqlDbType.Int,4,RegFee),
               db.CreateInParam("@AdmFee",SqlDbType.Int,4,AdmFee),
               db.CreateInParam("@SecFee",SqlDbType.Int,4,SecFee),
               db.CreateInParam("@ExamsFee",SqlDbType.Int,4,ExamsFee),
               db.CreateInParam("@SportsFee",SqlDbType.Int,4,SportsFee),
               db.CreateInParam("@TutionFee",SqlDbType.Int,4,TutionFee),
               db.CreateInParam("@CollFund",SqlDbType.Int,4,CollegeFund),
               db.CreateInParam("@CompFee",SqlDbType.Int,4,CompFee),
               db.CreateInParam("@TransFee",SqlDbType.Int,4,TransportFee),
               db.CreateInParam("@LateFee",SqlDbType.Int,4,LateFee),
               db.CreateInParam("@Misc",SqlDbType.Int,4,Misc),
               db.CreateInParam("@Total",SqlDbType.Int,4,Total),
               db.CreateInParam("@Payed",SqlDbType.Int,4,Payed),
               db.CreateInParam("@PayDate",SqlDbType.DateTime,8,PayDate),
               db.CreateInParam("@CurrArrears",SqlDbType.Int,4,CurrArrears),
               db.CreateInParam("@PrevArrears",SqlDbType.Int,4,PrevArrears),
                         };
         db.ExecuteStoredProcedure("StudentFee_Update", ref prams);
         return true;
     }
Esempio n. 8
0
      public bool ChangePwd(int uid,string pwd)
      {
          DbAccess db = new DbAccess();

          SqlParameter[] prams ={                
               db.CreateInParam("@UID",SqlDbType.Int,4,uid),
              db.CreateInParam("@Password",SqlDbType.VarChar,10,pwd),
                             
            };
          db.ExecuteStoredProcedure("User_ChangePwd", ref prams);
          return true;
      }