//**********************************************************************************
public SqlCommand EditOneBranches(Branches_Info objBranches_Info)
{
SqlCommand command = new SqlCommand("Update Branches Set Name= @Name Where ID= @ID");
command.CommandType = CommandType.Text;
command.Parameters.Add("@ID", SqlDbType.NVarChar, 25).Value = objBranches_Info.ID;
command.Parameters.Add("@Name", SqlDbType.NVarChar, 135).Value = objBranches_Info.Name;
this.AddCommand(command);
return(command);
}
public SqlCommand CreateOneBranches(Branches_Info objBranches_Info)
{
SqlCommand command = new SqlCommand("INSERT INTO Branches(ID, Name) VALUES (@ID, @Name)");
command.CommandType = CommandType.Text;
command.Parameters.Add("@ID", SqlDbType.NVarChar, 25).Value = objBranches_Info.ID;
command.Parameters.Add("@Name", SqlDbType.NVarChar, 135).Value = objBranches_Info.Name;
this.AddCommand(command);
return(command);
}
protected int Delete(Branches_Info obj)
{
if (obj == null)
{
throw new Exception("Invalid data input");
}
_dalBranch.RemoveOneBranches(obj.ID);
if (_dalBranch.Execute())
{
return(_dalBranch.LastRecordsEffected);
}
else
{
throw _dalBranch.GetException;
}
}
private Branches_Info GenerateObj(DataRow ordBranches)
{
if (ordBranches == null)
{
throw new Exception("");
}
Branches_Info objBranches_Info = new Branches_Info();
if (ordBranches["ID"] != DBNull.Value)
{
objBranches_Info.ID = Convert.ToString(ordBranches["ID"]);
}
if (ordBranches["Name"] != DBNull.Value)
{
objBranches_Info.Name = Convert.ToString(ordBranches["Name"]);
}
return(objBranches_Info);
}
public static int Update(Branches_Info obj)
{
return(dal_branch.Update(obj.ID, obj.Name));
}
public static int Insert(Branches_Info obj)
{
return(dal_branch.Insert(obj.ID, obj.Name));
}