protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack == false)
{
if (Request.QueryString["lccod"] == null)
{
Response.Redirect("frmsrcles.aspx");
}
else
{
Educom.clslescol obj = new Educom.clslescol();
DataSet ds = obj.lescoldet(Convert.ToInt32(Request
.QueryString["lccod"]));
Label1.Text = ds.Tables[0].Rows[0]["lescoltit"].ToString();
Label2.Text = Convert.ToDateTime(ds.Tables[0].Rows[0]["lescoldat"]).ToShortDateString();
Label3.Text = "$" + ds.Tables[0].Rows[0]["lescolcst"].ToString();
Label4.Text = ds.Tables[0].Rows[0]["nor"].ToString();
Label5.Text = ds.Tables[0].Rows[0]["catnam"].ToString();
Literal1.Text = ds.Tables[0].Rows[0]["lescolsec"].ToString();
Literal2.Text = ds.Tables[0].Rows[0]["lescoldsc"].ToString();
Image1.ImageUrl = "~/lescol/" + ds.Tables[0].Rows[0]["lescolcod"].ToString()
+ ds.Tables[0].Rows[0]["lescolpic"].ToString();
Image2.ImageUrl = "~/prfpics/" + ds.Tables[0].Rows[0]["prfcod"].ToString()
+ ds.Tables[0].Rows[0]["prfpic"].ToString();
Label6.Text = ds.Tables[0].Rows[0]["nam"].ToString();
Label7.Text = ds.Tables[0].Rows[0]["prfdsc"].ToString();
DataList1.DataSource = obj.dspusrlescol(
Convert.ToInt32(ds.Tables[0].Rows[0]["prfcod"]),
Convert.ToInt32(Request.QueryString["lccod"]));
DataList1.DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["colcod"] == null)
{
Response.Redirect("frmprf.aspx");
}
else
{
Educom.clslescol obj = new Educom.clslescol();
List <Educom.clslescolprp> k = obj.find_rec(Convert.ToInt32(Session["colcod"]));
Label1.Text = k[0].lescoltit;
}
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Header)
{
Educom.clscat obj = new Educom.clscat();
List <Educom.clscatprp> k = obj.find_rec(Convert.ToInt32
(Request.QueryString["ccod"]));
Educom.clslescol obj1 = new Educom.clslescol();
DataSet ds = obj1.srclescol(k[0].catcod);
Label lbl = (Label)(e.Row.FindControl("Label1"));
lbl.Text = k[0].catnam + " (" +
ds.Tables[0].Rows.Count.ToString() + ")";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack == false)
{
if (Request.QueryString["ccod"] == null)
{
Response.Redirect("frmmycol.aspx");
}
else
{
Educom.clslescol obj = new Educom.clslescol();
List <Educom.clslescolprp> k = obj.find_rec(Convert
.ToInt32(Request.QueryString["ccod"]));
Label1.Text = k[0].lescoltit;
}
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
Educom.clslescol obj = new Educom.clslescol();
Educom.clslescolprp objprp = new Educom.clslescolprp();
objprp.lescolcod = Convert.ToInt32(GridView1.DataKeys
[e.RowIndex][0]);
if (Convert.ToChar(GridView1.DataKeys[e.RowIndex][1])
== 'P')
{
objprp.lescolpubsts = 'N';
}
else
{
objprp.lescolpubsts = 'P';
}
obj.updlescolsts(objprp);
GridView1.DataBind();
e.Cancel = true;
}
protected void Page_Load(object sender, EventArgs e)
{
Educom.clslescol obj = new Educom.clslescol();
DataSet ds = obj.lescoldet(Convert.ToInt32
(Session["colcod"]));
//Label1.Text = ds.Tables[0].Rows[0]["lescoltit"].ToString();
Label2.Text = Convert.ToDateTime(ds.Tables[0].Rows[0]["lescoldat"]).ToShortDateString();
Label3.Text = "$" + ds.Tables[0].Rows[0]["lescolcst"].ToString();
Label4.Text = ds.Tables[0].Rows[0]["nor"].ToString();
Label5.Text = ds.Tables[0].Rows[0]["catnam"].ToString();
Literal1.Text = ds.Tables[0].Rows[0]["lescolsec"].ToString();
Literal2.Text = ds.Tables[0].Rows[0]["lescoldsc"].ToString();
Image1.ImageUrl = "~/lescol/" + ds.Tables[0].Rows[0]["lescolcod"].ToString()
+ ds.Tables[0].Rows[0]["lescolpic"].ToString();
Image2.ImageUrl = "~/prfpics/" + ds.Tables[0].Rows[0]["prfcod"].ToString()
+ ds.Tables[0].Rows[0]["prfpic"].ToString();
Label6.Text = ds.Tables[0].Rows[0]["nam"].ToString();
Label7.Text = ds.Tables[0].Rows[0]["prfdsc"].ToString();
}
protected void Button1_Click(object sender, EventArgs e)
{
Educom.clslescol obj = new Educom.clslescol();
Educom.clslescolprp objprp = new Educom.clslescolprp();
objprp.lescoltit = TextBox1.Text;
objprp.lescoldsc = TextBox2.Text;
objprp.lescolsec = TextBox4.Text;
objprp.lescolusrcod = Convert.ToInt32(Session["cod"]);
objprp.lescolcatcod = Convert.ToInt32(DropDownList1
.SelectedValue);
objprp.lescolcst = Convert.ToSingle(TextBox3.Text);
objprp.lescoldat = DateTime.Now;
if (CheckBox1.Checked == true)
{
objprp.lescolpubsts = 'P';
}
else
{
objprp.lescolpubsts = 'N';
}
String s = FileUpload1.PostedFile.FileName;
if (s != "")
{
s = s.Substring(s.LastIndexOf('.'));
}
objprp.lescolpic = s;
Int32 a = obj.save_rec(objprp);
if (s != "")
{
FileUpload1.PostedFile.SaveAs(
Server.MapPath("../lescol") + "//" + a.ToString() + s);
}
Response.Redirect("frmmycol.aspx");
}
