public int CreateRack(RackMaster rackMaster)
{
Query = "exec proc_Rack_Master '" + rackMaster.rak_Rack_Id + "','" + rackMaster.rak_Rack_Number + "','" + rackMaster.rak_Rack_Name + "','" + rackMaster.rak_User + "'";
return(Convert.ToInt32(caObjects.ExecuteQuery(Query)));
}
public string CreateUser(User user)
{
Query = "EXEC proc_User_Master '" + user.um_User_Id + "', '" + user.um_User_Name + "', '" + user.um_First_Name + "','" + user.um_Last_Name + "','" + user.um_Status + "','" + user.um_User + "'";
return(caObjects.ExecuteQuery(Query).ToString());
}
public int CreateVehicle(VehicleMaster vehicleMaster)
{
Query = "exec proc_Vehicle_Master '" + vehicleMaster.vm_Vehicle_Id + "','" + vehicleMaster.vm_Vehicle_Number + "','" + vehicleMaster.vm_Vehicle_desc + "','" + vehicleMaster.vm_Status + "','" + vehicleMaster.vm_user + "'";
return(Convert.ToInt32(caObjects.ExecuteQuery(Query)));
}
public int CreateRole(RoleMaster roleMaster)
{
Query = "exec proc_Roles_Master '" + roleMaster.rm_RoleId + "','" + roleMaster.rm_RoleName + "','" + roleMaster.rm_Status + "','" + roleMaster.rm_User + "'";
return(Convert.ToInt32(caObjects.ExecuteQuery(Query)));
}