private void AddRIPresident()
{
try
{
RIPresident rip = new RIPresident();
try
{
rip.District_no = int.Parse(txtDistNo.Text.Trim().ToString());
}
catch { rip.District_no = 0; }
try
{
rip.Participant = int.Parse(txtParticepant.Text.Trim().ToString());
}
catch
{
rip.Participant = 0;
}
rip.Description = txtData.Content;
rip.Year = DDLYear.SelectedItem.Text.Trim().ToString();
rip.Fname = txtFName.Text.Trim().ToString();
rip.Mname = txtMName.Text.Trim().ToString();
rip.Lname = txtLName.Text.Trim().ToString();
rip.Club_name = txtClubName.Text.Trim().ToString();
rip.District = txtDistrict.Text.Trim().ToString();// Location
rip.Country = txtCountry.Text.Trim().ToString();
rip.Theme = txtTheme.Text.Trim().ToString();
rip.Convention = txtConvention.Text.Trim().ToString();
SaveImages img = new SaveImages();
string pimg = img.AddImages(FileUploadPhoto.PostedFile, "RIPresidentPhotos");
rip.President_image = pimg;
string theme_logo = img.AddImages(FileUploadPhoto.PostedFile, "RIPresidentLogo");
rip.Theme_logo = theme_logo;
string convention_image = img.AddImages(FileUploadPhoto.PostedFile, "RIPresidentLogo");
rip.Convention_image = convention_image;
int exe = rip.AddRIPresident();
if (exe > 0)
{
clear();
string jv = "<script>alert('Record Added Successfully');</script>";
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "alert", jv, false);
}
}
catch { }
}
private void UpdateRIPresident(int id)
{
try
{
RIPresident rip = new RIPresident();
try
{
rip.District_no = int.Parse(txtDistNo.Text.Trim().ToString());
}
catch { rip.District_no = 0; }
try
{
rip.Participant = int.Parse(txtParticepant.Text.Trim().ToString());
}
catch
{
rip.Participant = 0;
}
rip.Description = txtData.Content;
rip.Id = id;
rip.Year = DDLYear.SelectedItem.Text.Trim().ToString();
rip.Fname = txtFName.Text.Trim().ToString();
rip.Mname = txtMName.Text.Trim().ToString();
rip.Lname = txtLName.Text.Trim().ToString();
rip.Club_name = txtClubName.Text.Trim().ToString();
rip.District = txtDistrict.Text.Trim().ToString();
rip.Country = txtCountry.Text.Trim().ToString();
rip.Theme = txtTheme.Text.Trim().ToString();
rip.Convention = txtConvention.Text.Trim().ToString();
SaveImages img = new SaveImages();
string pimg = img.AddImages(FileUploadPhoto.PostedFile, "RIPresidentPhotos");
rip.President_image = pimg;
string theme_logo = img.AddImages(FileUploadPhoto.PostedFile, "RIPresidentLogo");
rip.Theme_logo = theme_logo;
string convention_image = img.AddImages(FileUploadPhoto.PostedFile, "RIPresidentLogo");
rip.Convention_image = convention_image;
int exe = rip.UpdateRIPresident();
if (exe > 0)
{
clear();
showmsg("Record updated successfully !", "view_ri_president.aspx");
}
}
catch { }
}
private void AddSponser()
{
int maxOrdNo = GetMaxOrdNo();
string path = "";
try
{
DBconnection obj = new DBconnection();
obj.SetCommandSP = "z_AddSponser_Dist";
SaveImages img = new SaveImages();
path = img.AddImages(FileUpload1.PostedFile, "Sponsers_Logo");
obj.AddParam("@start_date", DateTime.Parse(StartDate.SelectedDate.ToString()));
obj.AddParam("@end_date", DateTime.Parse(EndDate.SelectedDate.ToString()));
obj.AddParam("@title", txtTitle.Text.ToString());
obj.AddParam("@url", txtURL.Text.ToString());
obj.AddParam("@status", DDLStatus.SelectedItem.Text.Trim().ToString());
obj.AddParam("@logo", path);
obj.AddParam("@display_order", maxOrdNo + 1);
int exe = obj.ExecuteNonQuery();
if (exe > 0)
{
clear();
string jv = "<script>alert('Record has been added successfully');</script>";
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "alert", jv, false);
}
}
catch { }
}
private void UpdateSponser(int id)
{
string path = "";
try
{
DBconnection obj = new DBconnection();
obj.SetCommandSP = "z_UpdateSponser_Dist";
if (FileUpload1.PostedFile != null)
{
path = Session["logo"].ToString();
}
else
{
SaveImages img = new SaveImages();
path = img.AddImages(FileUpload1.PostedFile, "Sponsers_Logo");
}
obj.AddParam("@id", id);
obj.AddParam("@start_date", DateTime.Parse(StartDate.SelectedDate.ToString()));
obj.AddParam("@end_date", DateTime.Parse(EndDate.SelectedDate.ToString()));
obj.AddParam("@title", txtTitle.Text.ToString());
obj.AddParam("@url", txtURL.Text.ToString());
obj.AddParam("@status", DDLStatus.SelectedItem.Text.Trim().ToString());
obj.AddParam("@logo", path);
int exe = obj.ExecuteNonQuery();
if (exe > 0)
{
clear();
showmsg("Record has been updated successfully !", "view_sponsors.aspx");
}
}
catch { }
}
private void UpdateBulletin(int id)
{
string path, mast_head = "";
try
{
DBconnection obj = new DBconnection();
obj.SetCommandSP = "z_UpdateBulletin";
SaveImages img = new SaveImages();
path = img.AddImages(FileUpload1.PostedFile, "Bulletin");
mast_head = img.AddImages(FileUpload2.PostedFile, "Bulletin");
try
{
if (path == "")
{
obj.AddParam("@bulletin", Session["Bulletin"].ToString());
}
else
{
obj.AddParam("@bulletin", path);
}
}
catch { obj.AddParam("@bulletin", ""); }
try
{
if (mast_head == "")
{
obj.AddParam("@mast_head", Session["MastHead"].ToString());
}
else
{
obj.AddParam("@mast_head", mast_head);
}
}
catch { obj.AddParam("@mast_head", ""); }
obj.AddParam("@id", id);
obj.AddParam("@title", txtTitle.Text.ToString());
obj.AddParam("@frequency", rbtnFrequency.SelectedItem.Text.ToString());
obj.AddParam("@status", DDLStatus.SelectedItem.Text.Trim().ToString());
int i = int.Parse(rbtnFor.SelectedValue.ToString());
if (i == 0)
{
obj.AddParam("@DistrictClubID", 0);
}
else
{
int cid = int.Parse(DDLClubName.SelectedValue.ToString());
obj.AddParam("@DistrictClubID", cid);
}
int exe = obj.ExecuteNonQuery();
if (exe > 0)
{
clear();
showmsg("Record updated successfully !", "view_bulletin.aspx");
// string jv = "<script>alert('Record Added Successfully');</script>";
// ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "alert", jv, false);
}
}
catch { }
}
private void AddBulletin()
{
string path, mast_head = "";
try
{
DBconnection obj = new DBconnection();
obj.SetCommandSP = "z_AddBulletin";
obj.AddParam("@added_by", "Admin");
int i = int.Parse(rbtnFor.SelectedValue.ToString());
if (i == 0)
{
obj.AddParam("@DistrictClubID", 0);
}
else
{
int cid = int.Parse(DDLClubName.SelectedValue.ToString());
obj.AddParam("@DistrictClubID", cid);
}
SaveImages img = new SaveImages();
path = img.AddImages(FileUpload1.PostedFile, "Bulletin");
mast_head = img.AddImages(FileUpload2.PostedFile, "Bulletin");
//try
//{
// foreach (UploadedFile file in RadAsyncUpload1.UploadedFiles)
// {
// fileSize = file.ContentLength;
// file_name = file.FileName;
// file_name = file_name.Substring(file_name.LastIndexOf("\\") + 1);
// string imageTime = System.DateTime.Now.ToString();
// imageTime = imageTime.Replace("/", "");
// imageTime = imageTime.Replace("-", "");
// imageTime = imageTime.Replace(":", "");
// imageTime = imageTime.Replace(" ", "");
// ext = file_name.Substring(file_name.LastIndexOf("."));
// file_name = file_name.Substring(0, file_name.LastIndexOf("."));
// file_name = file_name + "_" + imageTime + ext;
// path = Server.MapPath("~/Bulletin/");
// path = path + "/" + file_name;
// file.SaveAs(path);
// }
//}
//catch { }
obj.AddParam("@title", txtTitle.Text.ToString());
obj.AddParam("@frequency", rbtnFrequency.SelectedItem.Text.ToString());
obj.AddParam("@status", DDLStatus.SelectedItem.Text.Trim().ToString());
obj.AddParam("@bulletin", path);
obj.AddParam("@mast_head", mast_head);
int exe = obj.ExecuteNonQuery();
if (exe > 0)
{
clear();
string jv = "<script>alert('Record Added Successfully');</script>";
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "alert", jv, false);
}
}
catch { }
}
