public void UpdateGroup(int id, GroupMasterData Updategroupmaster)
{
DbCommand dbcommand = myDataBase.GetStoredProcCommand(DBConstant.Update_Group);
myDataBase.AddInParameter(dbcommand, "@Id", DbType.Int32, id);
myDataBase.AddInParameter(dbcommand, "@GroupName", DbType.String, Updategroupmaster.GroupName);
myDataBase.AddInParameter(dbcommand, "@grouparea", DbType.String, Updategroupmaster.GroupArea);
myDataBase.ExecuteNonQuery(dbcommand);
}
public List <GroupMasterData> ReadGroupMaster()
{
List <GroupMasterData> lst = new List <GroupMasterData>();
// DbCommand dbcommand = myDataBase.GetStoredProcCommand(DBConstant.LIST_AGENT);
DbCommand dbcommand = myDataBase.GetSqlStringCommand("select * from Group_Master");
using (IDataReader reader1 = myDataBase.ExecuteReader(dbcommand))
{
while (reader1.Read())
{
GroupMasterData groupmaster = new GroupMasterData();
groupmaster.GroupId = GetIntegerFromDataReader(reader1, "Group_ID");
groupmaster.GroupName = GetStringFromDataReader(reader1, "Group_Name");
lst.Add(groupmaster);
}
}
return(lst);
}
public List <GroupMasterData> ReadCounryIdByID(int id)
{
List <GroupMasterData> lst = new List <GroupMasterData>();
DbCommand dbcommand = myDataBase.GetSqlStringCommand("select * from Group_to_country where FK_Group_ID='" + id + "'");
//myDataBase.AddInParameter(dbcommand, "@Id", DbType.String, id);
//DbCommand dbcommand = myDataBase.GetSqlStringCommand("select * from Group_Master");
using (IDataReader reader1 = myDataBase.ExecuteReader(dbcommand))
{
while (reader1.Read())
{
GroupMasterData masterdata = new GroupMasterData();
masterdata.GroupId = GetIntegerFromDataReader(reader1, "FK_Group_ID");
masterdata.CountryId = GetIntegerFromDataReader(reader1, "country_ID");
lst.Add(masterdata);
}
}
return(lst);
}
public List <GroupMasterData> editgroup(int id)
{
List <GroupMasterData> lst = new List <GroupMasterData>();
DbCommand dbcommand = myDataBase.GetStoredProcCommand(DBConstant.Edit_Group);
myDataBase.AddInParameter(dbcommand, "@Id", DbType.String, id);
//DbCommand dbcommand = myDataBase.GetSqlStringCommand("select * from Group_Master where Group_ID ='"+id+"' ");
using (IDataReader reader1 = myDataBase.ExecuteReader(dbcommand))
{
while (reader1.Read())
{
GroupMasterData Editmasterdata = new GroupMasterData();
Editmasterdata.GroupName = GetStringFromDataReader(reader1, "Group_Name");
Editmasterdata.GroupId = GetIntegerFromDataReader(reader1, "Group_ID");
Editmasterdata.GroupArea = GetStringFromDataReader(reader1, "Group_Area");
lst.Add(Editmasterdata);
}
}
return(lst);
}
public List <GroupMasterData> ReadCountry(int id)
{
List <GroupMasterData> lst = new List <GroupMasterData>();
DbCommand dbcommand = myDataBase.GetStoredProcCommand(DBConstant.Read_Country);
myDataBase.AddInParameter(dbcommand, "@Id", DbType.String, id);
//DbCommand dbcommand = myDataBase.GetSqlStringCommand("select * from Group_Master");
using (IDataReader reader1 = myDataBase.ExecuteReader(dbcommand))
{
while (reader1.Read())
{
GroupMasterData masterdata = new GroupMasterData();
masterdata.GroupName = GetStringFromDataReader(reader1, "Group_Name");
masterdata.GroupId = GetIntegerFromDataReader(reader1, "FK_Group_ID");
masterdata.CountryId = GetIntegerFromDataReader(reader1, "country_ID");
masterdata.CountryName = GetStringFromDataReader(reader1, "COUNTRY_NAME");
lst.Add(masterdata);
}
}
return(lst);
}
public List <GroupMasterData> InsertGroupDetail(GroupMasterData groupmaster)
{
int GroupId;
int success;
List <GroupMasterData> lst = new List <GroupMasterData>();
DbCommand dbCommand = myDataBase.GetStoredProcCommand(DBConstant.Insert_GroupDetai);
myDataBase.AddInParameter(dbCommand, "@_inGroupName", DbType.String, groupmaster.GroupName);
myDataBase.AddInParameter(dbCommand, "@_inGroupArea", DbType.String, groupmaster.GroupArea);
myDataBase.AddOutParameter(dbCommand, "@GroupId", DbType.Int32, 20);
myDataBase.AddOutParameter(dbCommand, "@Success", DbType.Int32, 10);
myDataBase.ExecuteNonQuery(dbCommand);
int.TryParse(myDataBase.GetParameterValue(dbCommand, "@Success").ToString(), out success);
int.TryParse(myDataBase.GetParameterValue(dbCommand, "@GroupId").ToString(), out GroupId);
groupmaster.Success = success;
groupmaster.GroupId = GroupId;
lst.Add(groupmaster);
return(lst);
}
public void InsertGroupToCountry(GroupMasterData groupMaster)
{
DbCommand dbCommand = myDataBase.GetSqlStringCommand("insert into Group_to_country(FK_Group_ID,Country_ID) values(" + groupMaster.GroupId.ToString() + "," + groupMaster.CountryId.ToString() + ")");
myDataBase.ExecuteNonQuery(dbCommand);
}
public void UpdateGroupCountry(GroupMasterData updategroup, int id)
{
DbCommand dbCommand = myDataBase.GetSqlStringCommand("update Group_to_country set FK_Group_ID='" + updategroup.GroupId + "',Country_ID='" + updategroup.CountryId + "' where FK_Group_ID='" + id + "'");
myDataBase.ExecuteNonQuery(dbCommand);
}
public void UpdateGroupCountry(GroupMasterData groupmaster, int id)
{
Groupmasterdata.UpdateGroupCountry(groupmaster, id);
}
public void updategroup1(int Id, GroupMasterData updategroup)
{
Groupmasterdata.UpdateGroup(Id, updategroup);
}
public void InsertGroupCountry(GroupMasterData Groupmaster)
{
Groupmasterdata.InsertGroupToCountry(Groupmaster);
}
public List <GroupMasterData> insertgroup(GroupMasterData groupmaster)
{
return(Groupmasterdata.InsertGroupDetail(groupmaster));
}
protected void btnaddgroup_Click(object sender, EventArgs e)
{
int Id;
int check = 0;
List <GroupMasterData> lstcountry = new List <GroupMasterData>();
//Id = Convert.ToInt32(Chklistcountry.SelectedItem.Value);
foreach (ListItem item in Chklistcountry.Items)
{
if (item.Selected == true)
{
Id = Convert.ToInt32(item.Value);
lstcountry = GroupmasterBusiness.country(Id);
if (lstcountry.Count != 0)
{
if (lstcountry[0].CountryId == Convert.ToInt32(item.Value))
{
check = 1;
Response.Write("<Script Language=javascript>alert('" + lstcountry[0].CountryName + " is already exist in " + lstcountry[0].GroupName + " Group. ');</Script>");
break;
}
}
}
}
if (check == 0)
{
{
int success;
int groupId;
GroupMasterData groupmasterdata = new GroupMasterData();
groupmasterdata.GroupName = txtGroupName.Text;
groupmasterdata.GroupArea = txtGroupArea.Text;
List <GroupMasterData> lst = new List <GroupMasterData>();
lst = GroupmasterBusiness.insertgroup(groupmasterdata);
success = lst[0].Success;
groupId = lst[0].GroupId;
if (success == 1)
{
foreach (ListItem item in Chklistcountry.Items)
{
if (item.Selected == true)
{
GroupMasterData groupmaster = new GroupMasterData();
groupmaster.CountryId = Convert.ToInt32(item.Value);
groupmaster.GroupId = groupId;
GroupmasterBusiness.InsertGroupCountry(groupmaster);
}
}
Response.Write("<Script Language=javascript>alert('Group Added Successfullly. ');</Script>");
}
else
{
Response.Write("<Script Language=javascript>alert('Group Name is already exist. ');</Script>");
}
}
empty();
dropbind();
dropbind1();
}
}
protected void btnGroupupdate_Click(object sender, System.EventArgs e)
{
int id = Convert.ToInt32(ViewState["id"]);
int Id;
int checkcountry = 0;
//int c=Chklistcountry.Items.Count;
List <GroupMasterData> lstcountry = new List <GroupMasterData>();
//Id = Convert.ToInt32(Chklistcountry.SelectedItem.Value);
foreach (ListItem item in Chklistcountry.Items)
{
if (item.Selected == true)
{
Id = Convert.ToInt32(item.Value);
lstcountry = GroupmasterBusiness.country(Id);
if (lstcountry.Count != 0)
{
if (lstcountry[0].CountryId == Convert.ToInt32(item.Value))
{
if (lstcountry[0].GroupId == id)
{
}
else
{
checkcountry = 1;
Response.Write("<Script Language=javascript>alert('" + lstcountry[0].CountryName + " is already exist in " + lstcountry[0].GroupName + " Group. ');</Script>");
break;
}
}
}
}
}
if (checkcountry == 0)
{
GroupMasterData updatemastergroup = new GroupMasterData();
updatemastergroup.GroupName = txtGroupName.Text;
updatemastergroup.GroupArea = txtGroupArea.Text;
GroupmasterBusiness.updategroup1(id, updatemastergroup);
GroupmasterBusiness.deletegroup1(id);
foreach (ListItem item in Chklistcountry.Items)
{
if (item.Selected == true)
{
GroupMasterData groupmaster = new GroupMasterData();
groupmaster.CountryId = Convert.ToInt32(item.Value);
groupmaster.GroupId = id;
// GroupmasterBusiness.UpdateGroupCountry(groupmaster, id);
GroupmasterBusiness.InsertGroupCountry(groupmaster);
}
}
empty();
Response.Write("<Script Language=javascript>alert('Group Updated Successfullly. ');</Script>");
panel1.Visible = true;
ContolDiv.Visible = true;
UserReg.Visible = false;
dropbind();
}
}
