public string view(Student_admission student) { //Student_addmissions student_ = new Student_addmissions(); string s = "select *from student where St_id='" + student.Stdid + "'"; SqlCommand cmd1 = new SqlCommand(s, cn.GetConnection()); SqlDataReader reader = cmd1.ExecuteReader(); if (reader.Read()) { student.Stdid = reader["St_id"].ToString(); student.Sname = reader["St_name"].ToString(); student.Fname = reader["St_fname"].ToString(); student.Mname = reader["St_mname"].ToString(); student.Class = Convert.ToInt32(reader["St_class"]); student.Phone = reader["St_phone"].ToString(); student.Address = reader["St_address"].ToString(); student.Birthdate = Convert.ToDateTime(reader["St_date_of_birth"]); student.Religion = reader["St_Religion"].ToString(); student.Gender = reader["St_gender"].ToString(); student.Status = reader["St_type"].ToString(); student.Images = reader["St_image"].ToString(); } cn.getClose(); return(student.Images); }
public List <student_account_info> GetStudent_Account_Infos(Int32 stdid) { List <student_account_info> alist = new List <student_account_info>(); string q1 = "SELECT t2.stdId,t2.class,t2.pdate as Month,t2.pay as Payable,t1.paid as Paid,t2.pay-t1.paid as Dues,t1.paiddate FROM (select Stdid,FORMAT ( pdate , 'MM-yyyy' ) as pdate,pay,class from payable) t2 left JOIN(select t1.stdId,t1.paiddate,sum(t1.paid) as paid from(select Stdid,FORMAT ( pmonth , 'MM-yyyy' ) as paiddate,paid,class from payment group by stdId,class,paid,pmonth) t1 group by t1.stdId,t1.paiddate) t1 ON t2.stdId=t1.stdId and t2.pdate=t1.paiddate where t2.stdId=" + stdid + " group by t2.stdId,t2.class,t2.pdate,t2.pay,t1.paid,t1.paiddate order by t1.paiddate"; SqlCommand cmd1 = new SqlCommand(q1, cn.GetConnection()); SqlDataReader reader = cmd1.ExecuteReader(); while (reader.Read()) { student_account_info student_Account_Info = new student_account_info(); student_Account_Info.stdId = Convert.ToInt32(reader["stdId"].ToString()); student_Account_Info.Class = Convert.ToInt32(reader["class"].ToString()); // student_Account_Info.paidmonth = Convert.ToDateTime(reader["paidmonth"]); student_Account_Info.pmonth = Convert.ToDateTime(reader["Month"] == DBNull.Value ? null : (DateTime?)Convert.ToDateTime(reader["month"])); //object v = (reader.IsDBNull(3) ? null : reader["paidmonth"]); //student_Account_Info.paidmonth = Convert.ToDateTime((DateTime?)v); //employee.FirstName = sqlreader[indexFirstName] as string; //employee.Age = sqlreader[indexAge] as int? ?? default(int); // string s = reader["pmonth"].ToString(); student_Account_Info.Month = Convert.ToDateTime(reader["Month"].ToString()); student_Account_Info.payable = Convert.ToInt32(reader["payable"]); //d = Convert.ToDouble(reader["paid"] as float? ?? default(float)); student_Account_Info.paid = reader["paid"] as Int32? ?? default(int); student_Account_Info.dues = reader["dues"] as int? ?? default(int); alist.Add(student_Account_Info); } return(alist); }
public int saveadmit(Student_admission student) { Dbconnection cn = new Dbconnection(); string adate = DateTime.Now.ToString(); string ststus = "Active"; string q = "insert into student values('" + student.Stdid + "','" + student.Sname + "','" + student.Fname + "','" + student.Mname + "','" + student.Class + "','" + student.Phone + "','" + student.Address + "','" + student.Birthdate + "','" + adate + "','" + student.Religion + "','" + student.Gender + "','" + ststus + "','" + student.Images + "','" + student.Password + "')"; SqlCommand cmd = new SqlCommand(q, cn.GetConnection()); int row = cmd.ExecuteNonQuery(); cn.getClose(); return(row); }
public int save_month() { string stdid, classs; int cost, i = 1, p = 200; string pp = "bank", rr = "", tt = "1"; string pdate = DateTime.Now.ToString(); string q = "select promotion.Student_Id as studentid,promotion.Class as class,ClassCost.Cost as cost from promotion,ClassCost where promotion.Class = ClassCost.c_id "; SqlCommand cmd = new SqlCommand(q, cn.GetConnection()); SqlDataReader reade = cmd.ExecuteReader(); while (reade.Read()) { stdid = reade["studentid"].ToString(); classs = reade["class"].ToString(); cost = Convert.ToInt32(reade["cost"].ToString()); string l; l = "insert into Payment_Student(Studentid,Pmonth,payable,paid,pdate,paymethod,Money_Recpts,duestats,Class) values('" + stdid + "','" + pdate + "'," + cost + "," + p + ",'" + pdate + "','" + pp + "','" + rr + "','" + tt + "'," + classs + ")"; SqlCommand cmd1 = new SqlCommand(l, cn.GetConnection()); cmd1.ExecuteNonQuery(); } return(i); }
public string view(Student_admission student) { string s = "select *from student where St_id='" + student.Stdid + "'"; SqlCommand cmd1 = new SqlCommand(s, cn.GetConnection()); SqlDataReader reader = cmd1.ExecuteReader(); if (reader.Read()) { student.Images = reader["St_image"].ToString(); } cn.getClose(); return(student.Images); }